![]() ![]() Once you have enabled this feature in SSMS every time you open a New Query window it will Display Line Numbers. This way to can enable SSMS Show Line Numbers Feature. Select “Word Wrap” option under Settings if you would like to wrap the TSQL code. In General Page, under Display select the Check Box next to Line Numbers as shown in the above snippet and click OK. To Connect to SQL Server When all System Administrators are Locked Outģ. To Monitor Transaction Log File Usage in SQL Server To Identify the Location of Resource Database in SQL Server To Detect Virtual Log Files in SQL Server Transaction Log File To Start SQL Server with Minimal Configuration To Backup and Restore Resource Database in SQL Server To Configuring Database Instant File Initialization Feature of SQL Server To Enable Dedicated Administrator Connection in SQL Server SQL Delete Duplicate Rows from a SQL Table in SQL Server.Top Trending SQL Server DBA and Developer Articles and Tips Select General option as shown in the below snippet. In the Options dialog box on the left side pane expand the Text Editor and then expand Transact-SQL. Click Tools ⇒ Options as shown in the below snippet.Ģ. However, you can easily enable this feature by following the steps mentioned in this tip.ġ. In SQL Server Management Studio (SSMS) by default display line number feature is disabled. How to Display Line Numbers in SQL Server Management Studio (SSMS) The step mentioned in this tip is applicable to all versions of SQL Server Management Studio starting SQL Server 2005.įollow the simple steps mentioned in this article on How to Show Line Numbers in SQL Server Management Studioĭevelopers often encounters error in TSQL Code during development and this tip helps to Show Line Numbers in SQL Server or SSMS Show Line Numbers. This tip explains How to Show Line Number feature in SQL Server Management Studio (SSMS). SQL Server will show you an error message referencing you to a particular line number where the syntax error has occurred. SHOW Line Numbers in SQL Server Management StudioĪs a developer you may have often encounter errors while debugging TSQL code. This article explains how to enable SSMS show line numbers. SSMS Show Line Numbers | SSMS Line Numbers ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |