Interesting comment tricks, thanks for sharing.

I often keep multiple utility/investigation queries in the same file, too, and handle them similarly, but I like to make blocks inactive using "if 1...

I thought it was a trick question because the "none of the above" answer was provided, and "column" (without quotes) is a syntax error, not a valid column name. So...

Thanks for the reply, Michael.

I had trouble getting any feedback or advice regarding this topic on any of the forums I read, so eventually I just tried some things to...

Good article, Nakul, with thorough tests. Thanks for posting.

One small quibble: ansi_warnings is actually respected inside stored procedures. The behavior you demonstrated occurs because SQL Server doesn't raise errors (regardless...

Hi SqlSWAT,

Why do you say so? What factors play into the decision, etc? I'd appreciate any...