Home Forums SQL Server 2005 SQL Server 2005 Strategies Changing an existing column to identity RE: Changing an existing column to identity

  • October 5, 2011 at 10:18 am

    #1390804

    First thing, a single transaction is better.

    Secondly, I recommend renaming the old table instead of dropping immediately just in case.

    Third, are there indexes, triggers, etc. that also need to be created on the new table?

    My blog: SQL Soldier[/url]
    SQL Server Best Practices:     SQL Server Best Practices
    Twitter: @SQLSoldier
    My book: Pro SQL Server 2008 Mirroring[/url]
    Microsoft Certified Master: SQL Server, Data Platform MVP
    Database Engineer at BlueMountain Capital Management[/url]