Welsh Corgi (5/20/2014)
You are right you can't set the Identity Property to true.You can set the identity property to false by simply going into design mode and set the property to false.
I just wanted to know how to do it in T-SQL.
I guess I could find out how to do so by setting up a trace.
Thank you.
SSMS will create a new table, copy the data across, delete your original table and rename the new one.