How can I drop a table on a Linked Server ? [ All Languages » SQL Server »  Linked Server] Total Hit ( 2705) Rate this article:     Poor     Excellent   Submit Your Question/Comment about this article Rating

Assume that you have to execute the command DROP TABLE tableName on a linked server. The typical syntax that someone will try is: DROP TABLE serverName.master.dbo.TableName This for some reason fails ... If you were wondering why this happens then the answer is simple. The context of the user is unavailable to the linked server and hence you get this error. The only workaround possible is: EXEC serverName.database.userContext.sp_executesql N'drop table tableName' Essentially this would execute the sp_executesql on the linked server and drop the table. This is a typical requirement to have and a rare one also.

Related Article(s)

Submitted By : Nayan Patel  (Member Since : 5/26/2004 12:23:06 PM)
	Job Description : He is the moderator of this site and currently working as an independent consultant. He works with VB.net/ASP.net, SQL Server and other MS technologies. He is MCSD.net, MCDBA and MCSE. In his free time he likes to watch funny movies and doing oil painting.
View all (893) submissions by this author  (Birth Date : 7/14/1981 )