Search code examples
identity-insert

How to off the IDENTITY column of table in TSQL

i used 'SET IDENTITY_INSERT OFF' and this is executing successfully but in the table still identity on only

please help any one

Solution

  • This is going to drive you crazy but to do what you want use

    SET IDENTITY_INSERT ON

    This article explains it.

    The gist is that however misguided the decision, someone made the call that this statement would refer to whether your scripts could alter the identity column. Rather backwards, but that's just the way it is :D