I want to know is it possible to swich off an Identlty property on a column through T-SQL? I want to set up a job to turn off this property whist making some other changes to the table.

I know I can alter the properties through the database diagram
or the table designer. There is an idex on this field but the numbers are remining unique.


Thanks in advance