Database

-access 2003. -Vb6 classic I cannot have permission Sql Server, but have only a redaing on the sql table. If for you is a god way to use DTS in vb code this solution is welcome! Yes if is possible make all wiyh vb6 classic. Tks.

You can try the following transact-sql which will return all the table with the column definition of a particular database. SELECT * FROM targetDatabase.INFORMATION_SCHEMA.COLUMNS Thanks Md. Marufuzzaman I will not say I have failed 1000 times; I will say that I have discovered 1000 ways that can cause failure – Thomas Edison.

Cool! Thanks for updating it :) I are Troll :suss:

Thanks to Mycroft Holmes . its really helpful ! so much of happy ending...

Damian, Thank you for your answer. Actually, I added that on because it wasn't working without it. Now, since it wasn't working with it, I removed it...and now it is working again. I can't explain it, but since it is now working without it, you must be right. I do not know why it would not connect before. I have marked your answer as correct and I appreciate your assistance. Thank You. Best Regards, Pat

That's what i am doing dear! See the BACKUP DATABASE [Outbound_Vodafone] TO DISK = N'\\dataserver\Database\Outbound_VodafoneDifferential_9PM.bak' WITH DIFFERENTIAL , INIT but it's not working.

Just be careful with the HOSTS table entry; clearly and concisely document what was done and why. We had a problem last year with not being able to talk to a device because of undocumented HOST table entries. Tim

What I am trying to do is find out why a query that used to take 10ms is now taking 3 seconds to return a record set. I was hoping that dropping and then creating the table again might fix whatever had changed. There are only about 7000 records in the table most of the time, so a query should not take that long. I have followed up on this thread with a new question: A-tale-of-two-queries[^] If you have any insight on 'Audit Login' I would appreciate hearing about it. Thanx, >>>-----> MikeO

I followed the steps in your reply. Nothing looks to be wrong with the query. It even appears to execute normally in Management Studio. When I execute it in the code on the client though it takes about three seconds. The client app has been running successfully for about four years. Now it is getting bogged down by two queries. Both do field sums. Any ideas what could change on a server or connection that would slow down a SUM operation? This is a close approximation of the query that is taking so long: SELECT SUM(WorkSecs) as WorkTime, SUM(RunSecs) as RunTime FROM tblData WHERE Machine = 1 and Operator = 1 Thanx, >>>-----> MikeO

Thank you so much. That's exactly what I wanted. suchita

That seems to be what's installed, since it has locked itself. Tech Support claims to have a fix, but coincidentally, we just received a new server and they want to install it there. Since we have to read meters on Thursday, this might get interesting. Happily, I'm on vacation next week so it won't be my problem. :-D "A Journey of a Thousand Rest Stops Begins with a Single Movement"

Oh yeah, and this: AND isnull(ccsi.cs_deleted,0)=0 Is there an advantage to doing that rather than a simple IS NULL test? I'm not saying it's wrong, I'm saying I don't understand whether one is better than another.

Ok so the dumb ones are covered. It still looks like 1 is the cause of the problems. If you move to another folder and attach the files does the connection work OK then. I don't use express but with SQL Server the server instance has an identity/credentials and these are used to access the file system. I would presume permissions on the data/log folders is set up on install of the database. Other folders may need specific permissions. Never underestimate the power of human stupidity RAH

reza assar wrote: error is: "Missing semicolon (;) at end of sql statement" what should i do? Quote Selected Text try reading the error message, then engaging brain. Seriously, if you cant debug the error given the erro message then give up programming now.

Sorry By mistake.... I made the statement "But not able to populate the excel sheet." What i was: "But Not able to populate the Access Database". Thanks R.S.

You are asking for a strategy to manage your data, you are not going to get a satisfactory answer in a forum post. Most archiving is done by time stricture, anything that is 2 yo move to the archive database. This type of process requires that you copy (replicate) the data into an identical database and delete it from the production DB. Here you run up against data structure issues, all your chages to production structure needs to be reflected in the archive data. Queries can be written across both databases, but these are specific to archived results. Another strategy is data warehousing your data. You need to do some serious research into your business requirements before deciding on an archiving strategy. Never underestimate the power of human stupidity RAH

yes, it is.

Please read "_Damian S_"'s post again, it pretty much has the solution.

You should be able to keep the select as is (although I still don't see a reason for the Distinct clause), but also include in your select list the c.status field. Also include it in the group by and then you will have a row with all the different status values. And if you only want those "T" and "F" statuses, then add that condition to the where clause. :) Chris Meech I am Canadian. [heard in a local bar] In theory there is no difference between theory and practice. In practice there is. [Yogi Berra]

WScript.Sleep(2000) Why did you post this in SQL forum????? Die Energie der Welt ist konstant. Die Entropie der Welt strebt einem Maximum zu.