Prev: Help with SQL Query
Next: no answer?
From: SQL on 30 Jun 2010 17:01
We have a link server I am tryinjg to connect and insert into a table
that has a unique primary key index. Default server option is identity
insert on. I tried chaging identity insert off via source server but
it would not let me. Please let me know if you have any specific ideas
on how I can make this work.
From: Erland Sommarskog on 30 Jun 2010 18:13
SQL (texassqldba(a)gmail.com) writes:
> We have a link server I am tryinjg to connect and insert into a table
> that has a unique primary key index. Default server option is identity
> insert on. I tried chaging identity insert off via source server but
> it would not let me. Please let me know if you have any specific ideas
> on how I can make this work.

IDENTITY_INSERT is not a server option, it's a session option and
is per table. You cannot set it for a table on a linked server, since
that table is access through a session on the linked server.


--
Erland Sommarskog, SQL Server MVP, esquel(a)sommarskog.se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

 | 
Pages: 1
Prev: Help with SQL Query
Next: no answer?