question

Srinivas Govada avatar image
Srinivas Govada asked

or when a replication user is inserting into a NOT FOR REPLICATION identity column

I am replicating between 2 servers and i have 300 tables to replicate. I am using replication setup wizard from Sql server 2008 management studio. For every table I have Instead of Insert trigger not for replication. For this particular table'Shadowtable' I dont have Instead of Insert trigger. But I am getting this error Explicit value must be specified for identity column in table 'ShadowTable' either when IDENTITY_INSERT is set to ON or when a replication user is inserting into a NOT FOR REPLICATION identity column. (Source: MSSQLServer, Error number: 545) Please help me out
replication
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
Grant Fritchey avatar image
Grant Fritchey answered
I'd trust the error message. Is the identify column on that table marked as NOT FOR REPLICATION. Note, that is the identity column, not any triggers that you may have on the server.
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.