SQL Server Performance

Altering identity column to NOT FOR REPLICATION

Discussion in 'Performance Tuning for SQL Server Replication' started by Lesleyg, Jun 28, 2006.

  1. Lesleyg New Member

    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
  2. ndinakar Member

    AFAIK there is none. You have to do it in design view via EM.

    ***********************
    Dinakar Nethi
    SQL Server MVP
    ***********************

Share This Page