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!
Keep in mind that this doesn’t work in SSMS for “Denali” CTP 1 and we don’t know if this will be fixed in the next CTP.
Denny
Great.. I find a neat trick and it gets taken away..