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.
| Author |
Topic |
|
Shastryv
Posting Yak Master
145 Posts |
 Posted - 2003-11-20 : 18:55:12
|
| Is there a way to drop the objects on the linked server DB? Also any way to execute Select * in to xyz from abcBoth xyz and abc are on linked server.Thanks |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-11-20 : 19:03:02
|
| To drop a table on a linked server:EXEC serverName.database.userContext.sp_executesql N'drop table tableName'I don't think that you are going to be able to do SELECT INTO with a linked server. You can do this though:SELECT *INTO Table1FROM serverName.database.dbo.objectNameTara |
 |
|
|
|
|
|
Linked Server