[Solved] alter an existing table in sql server 2008, add AUTOINCREMENT for existing primary key - Co

If you have ms sql srvr mgmt studio you can do it. You just have to do it manually, not in script or command form. connect to your db show the table/column names in object explorer window right click on column name select modify in column properties tab

www.codeproject.com