Yup sure is. Use the following to allow explicit entry of a value in an identity column.
SET IDENTITY_INSERT tblTableName ON
To set it back:
SET IDENTITY_INSERT tblTableName OFF
|
Results 1 to 8 of 8
Thread: Switching Identity OffThreaded View
|
Click Here to Expand Forum to Full Width |