There is nothing in the question that suggests the PK is disabled, so I couldn't see any sensible answer. Went with the one where the first insert succeeds and...

Poor question. I only got this right by eliminating the impossible (0) and the extremely unlikely (20), thus leaving 2. However, the explanation as to why 2 is...

I completely disagree with GSquared that the sp_describe_cursor_columns can be a valid answer, even in a lawyerly way (and I've had enough of lawyers today having spent all day today...