• alter column to identity is very easy in ms sql server 2005

    just right click on column you want to alter and click on design and change identity to YES

    Enjoy!!!!!