I'm having a weird issue with IDENTITY_INSERT & am at a loss. Can anyone see what I'm missing?

Advertisements I’m getting an error when trying to execute the following statements complaining that IDENTITY_INSERT must be on in order for the insert to occur, but I am turning it on. SET IDENTITY_INSERT Thompson_GDM.dbo.employees ON GO INSERT INTO Thompson_GDM.dbo.employees SELECT [EmployeeId], [AssignmentId], [more columns…] FROM TMLAVSQLBIS.ThompsonMachinery.dbo.Employees; GO SET IDENTITY_INSERT Thompson_GDM.dbo.employees OFF go The error message… Read More I'm having a weird issue with IDENTITY_INSERT & am at a loss. Can anyone see what I'm missing?