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
 Import/Export (DTS) and Replication (2000)
 Need to transfer database from the remote linked server to local server

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2004-09-21 : 08:52:18
Reshmi writes "Hi all,
I need to transfer the database from the remote linked server to the local sql server. I am using the DTS import wizard with the third option i.e it should copy store procedures, views,indexes and triggers also, but it is giving the access violation error. The remote SQL server is SQL 2000 and local is SQL 7.0. Please help me to solve this problem.



Thanks,
Reshmi"
   

- Advertisement -