Welcome To TechBrothersIT: How To Reset Identity Column Value in SQL Server Table - SQL Server / T-SQL Tutorial Part 43
![The Merge command on the target table with the identity column gives an error, although we are not updating/inserting the identity column. - Microsoft Q&A The Merge command on the target table with the identity column gives an error, although we are not updating/inserting the identity column. - Microsoft Q&A](https://learn-attachment.microsoft.com/api/attachments/153692-pnbhk.jpg?platform=QnA)
The Merge command on the target table with the identity column gives an error, although we are not updating/inserting the identity column. - Microsoft Q&A
![Cannot insert explicit value for identity column in table when identity_insert is set to off - SQL Server Training Cannot insert explicit value for identity column in table when identity_insert is set to off - SQL Server Training](https://ellarr.com/wp-content/uploads/2016/03/identity-column-.png)
Cannot insert explicit value for identity column in table when identity_insert is set to off - SQL Server Training
![Cannot insert explicit value for identity column in table when identity_insert is set to off - SQL Server Training Cannot insert explicit value for identity column in table when identity_insert is set to off - SQL Server Training](https://ellarr.com/wp-content/uploads/2016/03/identity_insert-is-set-to-off-in-sql-server.png)