SQL2005 Error "can only be specified when a column list is used and IDENTITY_INSERT is ON"

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 <tablename> ON

{YOUR SQL INSERT STATEMENT}
After your SQL Statement:
SET IDENTITY_INSERT <tablename> OFF

------------------------------------------------------------------------------------------------

SET IDENTITY_INSERT <tablename> ON

INSERT INTO target_table (<column list>) SELECT (<column list>) from source_table

SET IDENTITY_INSERT <tablename> OFF