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 ONMarch 28, 2007Pinal DaveSQLSQL Download, SQL Error Messages, SQL Scripts, SQL Server, SQL Server SecurityThis error occurs when the 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. Let us learn about the IDENTITY_INSERT.Read More