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.
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.
Like us on FaceBook | Join the fastest growing SQL Server group on FaceBook
