This creates a new table as select from another:

select * into orders2 from Orders1

I want to create the table on another server. This 4 part notation
should work but It doesn't.

select * into server2.db_name.dbo.orders2 from
server1._db_name.dbo.Orders1;

Kevin J. Sexton

MS Sql Server LazyDBA home page