The problem is that I want to insert data from my local server to a linked
server into a table that I have to turn Identity_Insert ON temporarily.  I
cannot do the 4 part naming in a joined query (server.database.dbo.table),
so I have to resort to using dynamic SQL. So I must pass the dynamic SQL to
the linked server, but the linked server has no knowledge of my local
server, so I cannot do joins where I name the local server. The local server
cannot be a linked server on the remote server.  Help!  Is there a way to
truly temporarily turn off Identity fields for a table, instead of having to
have the entire query in the same statement as the identity_insert
statement?  Help!

Derek

can't delete a row from primary table - is there an SP for this?
Ranking Rows
T-SQL
Convert(datetime, '07/11/48') Returns Year 2048!!
UPDLOCK blocking readers