I get the error "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." Even when I place "SET IDENTITY_INSERT dbo.Table1 ON" just above the insert it doesn't work. I am confused because I do this all day long at work, but on my SQL Server 2005 Server at home gives me this error. Is it because I am trying to insert data from another database? I'm worried because I don't want to run into this problem at work, but as I stated, I do it all the time.
INSERT INTO dbo.Table1 (Col1)
SELECT Col1 FROM Database.dbo.Table2