Hi there,
I wrote a script to copy data from server1(epxress) to server2(2005 standard)
SET
identity_insert results onGO
insert
[server2].TEST.dbo.resultsselect
* from [server1].TEST.dbo.resultsresults table are identical with primary keys.
Problem is when run this code it gives an error
Msg 8101, Level 16, State 1, Line 1
An explicit value for the identity column in table 'dbo.results' can only be specified when a column list is used and IDENTITY_INSERT is ON.
I need a help to set it so when it tries to copy the existing row (same primary key), it ignores it and moves on to the next row..
Thanks guys!