Pages

Wednesday, August 21, 2013

SQL SERVER – Fix : Error 8101 An explicit value for the identity column in table can only be specified when a column list is used and IDENTITY_INSERT is ON | Journey to SQL Authority with Pinal Dave

This error occurs when user has attempted to insert a row containing a specific identity value into a table that contains an identity column. Run following commands according to your SQL Statement: Before your SQL Statement: SET IDENTITY_INSERT ON {YOUR SQL INSERT STATEMENT} After your SQL Statement: SET IDENTITY_INSERT OFF Reference : Pinal… Continue Reading...

Source: SQL SERVER – Fix : Error 8101 An explicit value for the identity column in table can only be specified when a column list is used and IDENTITY_INSERT is ON | Journey to SQL Authority with Pinal Dave