trying copy table to other server (both in the enterprise manager)

[michelleqw]

Dear SQL users,

We are trying to copy a table to an other server database, both servers are in the enterprise manager (2000).

Inside the same server it is very easy to copy a table to an other database with the next syntax:

Select * into targetdb.dbo.tbl_a from sourcedb.dbo.tbl_a

Is it possible to copy a table to an other server.
If yes, can someone pls give the source?

Nice regards,

Michelle.

 

[JarlH]

Since this is the ANSI SQL forum, we don't really discuss vendor specific issues here. Try an MS SQL Server instead, I suppose people there know MS SQL Server better.

 

[michelleqw]

Thanks.

Michelle.

 

[fredericofonseca]

Add the server name before the database name.

Regards

Frederico Fonseca
SysSoft Integrated Ltd

http://www.syssoft-int.com