I wrote some time back about changing the identity property of an existing table.
http://preethiviraj.blogspot.com/2007/09/table-partitioning.html
The author of Inside SQL Server, Kalen Delaney wrote about it recently. As I used to read her blogs, I wrote a reply to that.
http://sqlblog.com/blogs/kalen_delaney/archive/2007/07/13/did-you-know-it-s-in-the-books-online.aspx
Interestingly, my friend and co worker Jude Pieries too wrote about the same feature in his article
http://sqlserveruniverse.com/content/DEVL0400101022007SwitchingFromNonIDENTITY.aspx
PLEASE HAVE A LOOK!
No comments:
Post a Comment