Stop isql.exe and reboot your server. Remember, you will need to apply SQL Server sp5a it is required to run SQL 6.5 in a 2000 server, otherwise it won't work.

When...

I have a question out of curiosity, why you have to drop the table and recreate it later?

Anyway, I think the best option is to use the data compare utility...

This happened to me once. I got the solution here (as always) Where? Sorry, mi memory has been taking a nap since Woodstock!!

Anyway, What I got from here was: Detach...

Yes you can. Instead of giving you a big explanation of this matter (BOL explains better than I can), please refer to BOL and search for a section called "Creating...

I agree with the last statement. If the tape fails, who can guarantee tha you will have a healthy backup in case of system failure?

Best policy, run two sets (full...

Basically, the difference between delete and truncate is that truncate does not record any entry in the transaction log, which could create a problem if you have to roll back....

A few weeks back, I found the folowing script. Where? In SQL Server Central!!!

SELECT TOP 100 PERCENT

sysobjects.name AS Table_Name,

syscolumns.name AS Column_Name,

systypes.name AS Data_Type,

syscolumns.length

FROMsysobjects INNER JOIN

syscolumns ON sysobjects.id = syscolumns.id INNER...

Just a quick note. At the end of the convert you can see the 105? Well, you can change this one to 106 the date will show as 15...

Reapply SP2, it should reset all correctly. This happen to one of our divisions. Even though we do not recommend applying any fix until it is done in the test...

I forgot, I will look for the article link and posted as soon as possible, Thanks

A few weeks back, we had the same issue. There is Microsoft article in this regard. Unfortunatelly I do have the reference at this time. Essentially it says, that This...

I agree with the last statement. I did modified the script a couple of weeks back and it did not run as expected. I am using shrink log and truncate...

Thanks Andy. I was reading about Full text index right at this moment. I will check this out to see if this work better for this.

If you or anyone comes...

No, it does not. In any event you can run DBCC CHECKIDENT every now and then to make sure everything is as it should (See DBCC CHECKIDENT for a more...

Sorry. I forgot to mention that, the sql statement was working fine until the table got over 5 million (before the taable use to store around 1.5 to 1.7 million...