ssms-2017
I'm not able to see the Line number in the SQL Server 2017 Express, even if Line Number checked correctly
Here is the image of the option window with the Line Number Checked correctly
SQL Server 2017 Express Edition Windows 10 64 bits Following the below path Tools --> Options --> Text Editor --> Plain Text --> Line Number I tried multiple times shutting down the system, not sure what I'm missing here.
Solution
Assuming you are working with .sql files you will want to adjust the setting in this path Tools → Options → Text Editor → Transact-SQL → Line Numbers.
See my blog post about this here for more info.
- How to copy SSMS connections in dropdown to a new computer?
- SSMS Color tab based on connection string / Environment
- I want to create table or view from a recursion used to generate a date in ssms
- How do I return the most recent result for the week each week?
- Find the Min and Max date from two tables from a sql select statement
- Can't find sqlcmd.exe (SQL SERVER 2017)
- SUMIF then restart count
- I get this error Message "Invalid length parameter passed to the LEFT or SUBSTRING function."
- Syncing Metadata from Azure DataFactory to SQL Server database
- Syncing Metadata output from Datafactory in SQL Server database error using stored procedure: Json - Unexpected character 'S' is found at position 0
- How to debug T-SQL with SQL Server Management Studio 2017?
- I cannot find SQL Server browser
- Executing multiple queries in SSMS
- SQL restore is failing with an error when using SSMS
- calculate total sum from first month to the last month
- Optimizing queries that search for text
- Assign multiple values in declaration part
- Import data tier application is failing
- Make a master record out of several duplicate records for each id
- CAN THE COUNT FUNCTION IN SQL SERVER DB ACCEPT MULTIPLE VALUES
- How to use if else in SQL Server stored procedure
- Cannot see expected PRINT or RAISERROR output when a later error is raised
- Select statement return if there is a value and if there is no value
- I'm not able to see the Line number in the SQL Server 2017 Express, even if Line Number checked correctly
- SQL: Select from multiple JOINS in different subqueries
- How to filter a specific record in SQL Server within in the date range without removing other records?
- xml.node how to get value
- while runing DQSinstaller.exe it fails with following description why?
- How to pivot without knowing fixed columns in T-SQL
- Excel Pasting SQL Server Results Set Only Into Column A