SteelMillDon

Hi,

In errors and warnings lists there is a line number given where the error or warning occured. When I click on the error or warning it takes me to the correct sql script but I cannot find anyway to jump to the line number or at least turn on line number in the editor.

Is this possible to view line number in sql editor if so how

Thanks

Don



Re: Visual Studio Team System - Database Professionals How to View line numbers in SQL Editor

Jason Giuseponi

SteelMillDon,

Tools | Options | Text Editor | T-SQL90 | General

Under 'Display' check Line Numbers

THT,





Re: Visual Studio Team System - Database Professionals How to View line numbers in SQL Editor

Gert Drapers - MSFT

Yes, go to:

SQL 2000 projects: Tools | Options | Text Editor | T-SQL80 | Display Line numbers

SQL 2005 projects: Tools | Options | Text Editor | T-SQL90 | Display Line numbers

Or if you want to change it for all languages

Tools | Options | Text Editor | All Languages | Display Line numbers

-GertD





Re: Visual Studio Team System - Database Professionals How to View line numbers in SQL Editor

SteelMillDon

Thanks GertD!

I have been looking for this option in SQL Server management Studio also. You solved both for me!