When executing code in SQL Server Management Studio. Occasionally people make errors. If you find yourself counting thru your TSQL Batch up to “LINE 231” where your error is supposed to be, then this tip is for you.
Tip: Double Click on the Error message in the results pane. (In diagram below, see Lines circled in Red) This should jump immediately to the line of code containing the error & highlight it. (see diagram below, Line circled in Green)
9 times out of 10 is works perfectly. The other times the confusion is usually caused by SQL Engine having an issue with an earlier line of code. eg:
Versions supported: SQL 2005, SQL 2008, SQL 2008 R2. (From memory even worked in SQL2000)
I thought everyone knew this, so was surprised by the reaction at Tech-Ed. Hence the post.
Hope you found it useful