Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 DTS not exporting/importing stored procedures

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-01-28 : 12:17:37
Doug writes "Source: SQL 7.0, NT 4.0, NT SP5, SQL SP1
Destination: SQL 7.0, NT 4.0, NT SP6a, SQL SP2

Hope you can help. I'm trying to export a database from one SQL 7.0 server to another on the same network. I select "Transfer Objects and Data between SQL Server 7.0 databases," and it seems to do everything and finishes successfully. When I look at the destination stored procedures, they aren't there.

I just need to create a copy of the database on another server for testing. Is using Export/import the right way to do this? I need to include all objects.

Thank you in advance!"
   

- Advertisement -