That's because you are running a distributed query which needs to be a
logged operation becuase it uses the two-phase commit. 'select into' is
non-logged and therefore cannot be used in a distributed environment.

Mark.
www.allisonmitchell.com

-----Original Message-----
From: Sexton, Kevin [mailto:kevin.[Email Address Removed] 27 February 2002 20:53
To: [Email Address Removed] scripting across servers


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


---------------------------------------------------------------------
To unsubscribe, e-mail: mssqldba-[Email Address Removed] additional commands, e-mail: mssqldba-[Email Address Removed] message and any attachment are confidential and may be privileged or otherwise protected from disclosure. If you are not the intended recipient, please telephone or email the sender and delete this message and any attachment from your system. If you are not the intended recipient you must not copy this message or attachment or disclose the contents to any other person.

For further information about Clifford Chance please see our website at http://www.cliffordchance.com or refer to any Clifford Chance office.
MS Sql Server LazyDBA home page