"I must watch Thunderbird again. "

Sean, as an old James Bond fan, I think you mean Thunderball. 🙂

Thanks for the quick response. You know I did not even think to try and run it, I just assumed it was correct since it was in Books...

Have you tried to repair the file using the ODBC Administrator?

Go to control panel -> Administrative tools -> Data Sources (ODBC)

On the first tab User DSN, double click on...

This is interesting, in my case the file size was 36 Gb. I had done restores from files before that were 25 Gb with no problem. One...

Thanks for the detailed replies. That certainly explains the behavior.

CG

Wow, I would never thought SQL Server still has legacy code that goes that far back. Thanks for the explanation. However, I would think SQL Server should still...

Good article!

Can anyone tell me if you can link from SQL Server 2000 to 2005 (not 64 bit) and run queries from SQL Server 2000 against the 2005 server?

Thanks 

I'm woundering why if you just want to strip off the time you just can't use the convert function with the optional style argument.  In this case 101 would be...