Hello All,
I was testing replication on test server with,
i changed all identity column to NOT FOR Replication,but when i start replicating publisher
it changes all the identity column to non identity column on subsciber.
Other thing i try to change in the SP
"sp_MSins_insert Tablename"
Begin
set identity_insert Wednesday on
...
..
set identity_insert TableName off
END
But its inserting identity column values to table
I don't want it, i want identity column to autogenete in subscriber side.
How can i fixed this problem
Thanks