Interesting question. I'm surprised so many got it right - surely people don't use identity insert so much that they either know this from experience or have taken care to learn it so as not to find out the hard way? Certainly it's something I must have known once (when first learning to use SQL Server, some time in the mists of antiquity) but I had completely forgotten it so I got it wrong. So it was a useful reminder for me.