disbaling identity

[sianatia]

hi, i want to remove identity check for a table, i used SET IDENTITY_INSERT ON but it works just for one transaction,how can i disable identity forever (i need the Transaction for this operation)

[Rob Graham]

Alter the table, change the identity field to an ordinary integer (remove the identity attribute). Of course you will then be responsible for computing the value for new inserts... You could set a Unique constraint on the field to insure that it still rejects duplicates. Absolute faith corrupts as absolutely as absolute power Eric Hoffer The opposite of the religious fanatic is not the fanatical atheist but the gentle cynic who cares not whether there is a god or not. Eric Hoffer