Easy way to find error in script?

[bmacbmac]

Hi,

I have a huge script separated with a bunch of 'go' lines. I am getting a ton of results rows and right in the middle I am getting 'Incorrect syntax near '+'.

I can do a find for all of the '+' in my script to find the issue. But I'm wondering if there is an easier way to do this? Is there some sort of tool in SQL that can review my script for Syntax errors so I don't have to hunt and peck?

Thanks!

 

[gmmastros]

sometimes you can double click on the red error message and it will jump you to that part of the code.

-George
Microsoft SQL Server MVP
My Blogs
SQLCop
twitter
"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[philhege]

The only time it doesn't work is if the error is buried in a SELECT statement. Usually the red error message link will take you to the beginning of the SELECT.

-----------
With business clients like mine, you'd be better off herding cats.

 

[bmacbmac]

Where has this been all my life?????? Ya that works great. Wish I would have known this a few years ago.