Friday, 24 June 2011

How to Display Line Numbers in the Query Editor - SSMS 2005 and 2008

SQL Server 2008:

In SSMS go to Tools > Options to bring the window up below. Select 'Text Editor' then 'Transact-SQL'. Select the 'Line Number' option from the 'Display' section and click OK.

:SSMS_Linenumber


SQL Server 2005:

In SSMS go to Tools > Options to bring the window up below. Select 'Text Editor' then 'Plain Text'. Select the 'Line Number' option from the 'Display' section and click OK.


SSMS_Linenumber_2005

No comments:

Post a Comment