Thread: Set Identity Insert On Off - Microsoft SQL

How to Set Identity Insert On Off - Microsoft SQL
How do you set the insert on identity column on or off in MS SQL?

To set identity insert on:
SET IDENTITY_INSERT tablename ON

To set identity insert off:
SET IDENTITY_INSERT tablename OFF

Hello manek,
You have shown one way for setting Identity insert.
The other way is in which table you have to make Identity insert you have to go to the property of the table.
There you have to select the Identity specification and make it yes.

thanks for letting us know how to do Identity insert. very handy.

after using set identity_insert on,I got the error as Cannot perform SET operation as table is not a user table,can any body help me out?