Altering identity column to NOT FOR REPLICATION | SQL Server Performance Forums

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
***********************
]]>