Get Help:Ask a Question in our Forums|Report a Bug|More Help Resources
Feb 23, 2012 10:33 AM|LINK
you can easily add new column in table as identity
alter table TableName
Add ColumnName int identity(1,1)
but, to alter exisiting column and making it as identity is not straightforward... since, u might have some data in existing column which does not follow identity....
this article explains the details
hope this helps...