I run into situation where i have to insert explicit value for identity column and run into following error, which is expected. Incase you run into similar situation here is the solution to insert value into Identity column in SQL Server. Error: Msg 544, Level 16, State 1, Line 1 Cannot insert explicit value for identity column in table 'Users' when IDENTITY_INSERT is set to OFF. Cause of