SQL Server Forums - SET IDENTITY INSERT ON

You can't do IDENTITY_INSERT dynamically. Dynamic SQL exists in its own session, so you aren't able to get to it once you run the next command. You will have to hard code the table names. Tara Kizer aka tduggan

www.sqlteam.com