Real line numbers

Question

Post reply

Real line numbers

david.gray

SSC Eights!

Points: 968
More actions
February 20, 2009 at 4:09 am

#129235

Hi,
Is there any way to get SSMS to show the actual line number for an error rather
than the number in relation to the last GO?
I have a script of 39,000 lines and parsing the query tells me there's a problem near
the keyword 'AS'
Msg 156, Level 15, State 1, Line 2
Incorrect syntax near the keyword 'AS'.
Bit of a needle in a haystack as you can imagine.
Dave

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Madhivanan-208264 SSCertifiable Points: 7516 More actions · Answer 1

Double click the error

It will move the cursor to the specific line

Madhivanan

Failing to plan is Planning to fail

david.gray SSC Eights! Points: 968 More actions · Answer 2

Madhivanan (2/20/2009)
Double click the error
It will move the cursor to the specific line

Fantastic! That is so useful.

Regards

Dave

Madhivanan-208264 SSCertifiable Points: 7516 More actions · Answer 3

david.gray (2/20/2009)
Madhivanan (2/20/2009)
Double click the error
It will move the cursor to the specific line
Fantastic! That is so useful.
Regards
Dave

You are welcome 🙂

Madhivanan

Failing to plan is Planning to fail

Lowell SSC Guru Points: 323518 More actions · Answer 4

also from within SSMS:

Tools>>Options>>Text Editor

Expand "All Languages"

under the "Display" section, there is a semi-gray checkbox...uncheck and check to enforce line numbers for All languages and files.

Now line numbers appear on the left border of each document/sql you write /open.

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!