In short, where has DTS gone and how can I very quickly copy tables, data and sprocs from one server to another?!
More crucially, from SQL Server 2005 to SQL Server 2000.....
Our technical people, in their infinite wisdom, have upgraded across the board internally from 2000 to 2005 whilst our live web server is still 2000.
I've tried the Copy Database Wizard but it appears that the destination server must be 2005.
Sorted it. What a pain in the rear.
