Home Forums Article Discussions Article Discussions by Author Discuss content posted by Thomas Pieries Changing a Non-IDENTITY column to IDENTITY and vice versa RE: Changing a Non-IDENTITY column to IDENTITY and vice versa

  • February 21, 2008 at 4:43 pm

    #780913

    Thomas,

    I like the technique with partition switching. Thank you.

    BTW, for your method 2, you will need

    SET IDENTITY_INSERT Destination_TB ON;

    before the insert.

    \Sean