How do we remove an identity, from a sql table column which already has identity and data , without loosing the data and without having the need to copy data to new table
You should be able to just unclick the identity property in Enterprise manager and click save.
I Would generally unload to a temp table drop table, create altered table and reload data.
Using EM will in fact create a temp table and copy the data.
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
Viewing 3 posts - 1 through 2 (of 2 total)