da-zero (8/11/2010)
Developer 2005 (8/11/2010)
Both Question and answer don't have sufficient information about target.What is the purpose of IDENTITY_INSERT ?
And answer
SET IDENTITY_INSERT allows explicit values to be inserted into the identity column of a table.
SET IDENTITY_INSERT is not meaningful and you can not identify result until ON or OFF is not include in this statement. SET IDENTITY_INSERT it self not allows explicit values to be inserted into the identity column of a table until you don't include ON in this.
You forgot to mention permissions or it won't work. Cmon people, it was a simple question that if you want to know more about it follow the link that was posted. I think some people are just mad they didn't get their points. 🙂
Seriously though, thank you for the question.