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