"An explicit value for the identity column in table 'table1' can only be specified when a column list is used and IDENTITY_INSERT is ON.".
Solution and Explanation:
This error occurs when one tries to insert data into a column in which identity insert is on, in such case, we don’t need to insert data in such columns. For this ,Check the number of columns in the source and destination table(excluding one column for which identity insert is on). because it is possible , that you are mistakenly inserting data into destination column (for which identity insert is on).
Please provide your feedback for the post, if you find this post useful. Also Post your query or scenario, i will be happy to help.