IDENTITY Insert doesnt work for Linked servers
From: Sachin (Sachin_at_discussions.microsoft.com)
Date: 02/21/05
- Next message: Michael C#: "Re: MSCS Questions"
- Previous message: Daniel Gard: "call to xp_cmdshell from trigger problem"
- Next in thread: David Portas: "RE: IDENTITY Insert doesnt work for Linked servers"
- Reply: David Portas: "RE: IDENTITY Insert doesnt work for Linked servers"
- Messages sorted by: [ date ] [ thread ]
Date: Mon, 21 Feb 2005 07:51:02 -0800
Hi Everybody,
In my program, I am inserting rows from the source database to the
destination database which are on different servers. From source database,
with the help of the link server, I am connecting to the destination server.
In the destination table(destination db), I have one identity column which
is a primary key. But in that table, I need to insert the rows with the same
values as in the source table(source db). So i am using
SET IDENTITY_INSERT [linked server].[database].[user].[tablename] ON
But this when executed shows me an error - "Table does not exist or cannot
be opened for SET operation."
Please tell me how to make the identity insert ON on the table through the
linked server. I can execute the same command on any table on the same
database server, but not on destination database server.
Thanks.
- Next message: Michael C#: "Re: MSCS Questions"
- Previous message: Daniel Gard: "call to xp_cmdshell from trigger problem"
- Next in thread: David Portas: "RE: IDENTITY Insert doesnt work for Linked servers"
- Reply: David Portas: "RE: IDENTITY Insert doesnt work for Linked servers"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
