Is there a way to get the exact line an error occurs on in Query Analyzer?

When we have SQL syntax errors in Query Analyzer we get a Message like this:

>[Error] Script lines: 1-160 ------------------------

Most of the time, it is easy to figure out why there is a syntax error, however, in some cases we don't get a lot of details.  MS SQL Server Mgmt Studio usually (or gets you close enough)identifies the line number at which the error occurs, making it easy to troubleshoot. 

Is there a way to identify the exact line number that an error occurs at? 

Thanks.

Parents
No Data
Reply Children
No Data