SSMS Trick

Here’s an SSMS trick I discovered by accident the other day.

When you try to run a query and get a syntax error, you can double click on the error message in the message pane and the offending statement will be highlighted in the upper pane:

 

This works in the 2005 and 2008 versions of SSMS. Heck, this even works in 2000’s Query Analyzer.. Guess I’ve been missing out for several years!

3 thoughts on “SSMS Trick

Leave a Reply

Your email address will not be published. Required fields are marked *

I am a real person and can prove it by doing this math problem: (required) Time limit is exhausted. Please reload CAPTCHA.

This site uses Akismet to reduce spam. Learn how your comment data is processed.