We have a problem with our SQL 2000 server which we know is a product bug.
Is there anyway of importing, Copying the sql 2000 table back down to SQL 7 until the issue is resolved,
many thanksMy first suggestion would be the DTS Wizard (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dtssql/dts_tools_wiz_9e5g.asp). You can use a Linked Server (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_1_server_4uuq.asp), but it is a lot more work than a simple DTS package that does the same job in most cases.
-PatP
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment