The SQL Server error code 544 – Cannot insert explicit value for identity column, occurs when one tries to insert an explicit value for an identity column and identity_insert is off for that particular table.

1_SQL Server error code 544 - Cannot insert explicit value for identity column

As shown in above image, the insert query specifies an explicit value for the identity column sno. The query terminates with error as IDENTITY_INSERT is set to OFF. To resolve this, Set IDENTITY_INSERT to ON for tab le tblcheck and then execute the insert query as shown in below image.

2_SQL Server error code 544 - Cannot insert explicit value for identity column

 

Regards

Ahmad Osama

Like us on FaceBook Join the fastest growing SQL Server group on FaceBook

Follow me on TwitterFollow me on FaceBook