InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comTue, 21 May 2013 04:09:57 GMT20http://www.sqlservercentral.com/Forums/Topic1410909-391-1.aspxHello I have on the server 1.1.1.2i think SELECT * FROM [1.1.1.1].DATABASE.dbo.TABLEand try DROP TABLE table_name [1.1.1.1].DATABASE.dbo.TABLE; IF EXISTS (SELECT COUNT(*) FROM sys.object WHERE OBJECT_ID = OBJECT_ID(N'TABLE'))DROP TABLE IF EXISTS table_name [1.1.1.1].DATABASE.dbo.TABLE; but the second query i didnt use before :) Wed, 23 Jan 2013 23:48:18 GMTtony28http://www.sqlservercentral.com/Forums/Topic1410909-391-1.aspxHi,Can anyone let me know the syntax for "drop if exists" and "select * into from" using Linked Server tables.Wed, 23 Jan 2013 23:25:12 GMTSolitary Reaper