Can you please write a script that will set IDENTITY COLUMN to NOT FOR REPLICATION rather than going into Design table to do it.
I want a script that can do it for all tables with IDENTITY COLUMNS & rimary key
I try below script it give error:
alter table tb_Benefit
alter column b_SID add NOT FOR REPLICATION
Error:Server: Msg 170, Level 15, State 1, Line 5
Line 5: Incorrect syntax near 'NOT'.