April 23, 2009 at 7:08 pm
Is there any easy way to alter an existing table so that its INT primary key column can become an identity, without dropping/ re-creating / re-loading the table in SQL 2005 as column identity property is grayed out?
appreciate your time..
April 23, 2009 at 7:33 pm
I have posted the valid solution to your problem in the thread below.
http://www.sqlservercentral.com/Forums/Topic683681-1291-1.aspx
Kind regards,
Gift Peddie
April 23, 2009 at 8:26 pm
There are some methods to do this, take a look at this article:
Changing a Non-IDENTITY column to IDENTITY and vice versa
http://www.sqlservercentral.com/articles/T-SQL/61979/
---------------------
Alex Rosa
http://www.keep-learning.com/blog
April 23, 2009 at 9:50 pm
Great , thank you both for the links , that helps...
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply