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 Development (2000)
 Linked servers

Author  Topic 

cbecerra
Starting Member

38 Posts

Posted - 2001-05-30 : 10:17:17
I was wondering if anyone new of a way to copy a table to a linked server using a script. I have already linked the remote server and I thought that using SELECT INTO would be the best aproach for this task but as it turns out it does not work. Apparently SELECT INTO does not allow creating a table on a remote server. Does anyone know of another aproach.

Thanks
.Cesar

   

- Advertisement -