SQL Server Performance Forum – Threads Archive
Altering identity column to NOT FOR REPLICATION
Hi all, Can anyone tell me if there is a way in T-SQL to alter an identity column in a table so that the NOT FOR REPLICATION option is set? thanks,Lesley
AFAIK there is none. You have to do it in design view via EM. ***********************
Dinakar Nethi
SQL Server MVP
***********************
]]>