>Alex, > >I'll take a SWAG at this. Just don't blame me if I'm wrong.:-) > >One of the things I've noticed about SQL Server 2000, is that, when you export data, the index keys aren't copied as well. You mentioned your local box and the new server. This leads me to the following. > >Were the index keys rebuit?
Yes. All of them. And as I said queries are quick from SQL Server Analyzer. I'll be at the server on Monday and check the ODBC ideas mentioned.
"Once again, we come to the Holiday Season, a deeply religious time that each of us observes, in his own way, by going to the mall of his choice." -- Dave Barry