How can I determine installed SQL Server instances and their versions?

by

At a command line:

SQLCMD -L

or 

OSQL -L

(Note: must be a capital L)

This will list all the sql servers installed on your network. There are configuration options you can set to prevent a SQL Server from showing in the list. To do this…

At command line:

svrnetcn

In the enabled protocols list, select ‘TCP/IP’, then click properties. There is a check box for ‘Hide server’.

More Related Contents:

  1. LocalDB deployment on client PC
  2. SQL Server named instance with Visual Studio 2017 Installer project
  3. “Cannot open user default database. Login failed.” after installing SQL Server Management Studio Express
  4. Bootstrapping SQL Express from WiX?
  5. How to get the last row from a table in SQL Server?
  6. How do I fix the error ‘Named Pipes Provider, error 40 – Could not open a connection to’ SQL Server’?
  7. The order of a SQL Select statement without Order By clause
  8. How to get Time from DateTime format in SQL?
  9. Natural (human alpha-numeric) sort in Microsoft SQL 2005
  10. Select values from XML field in SQL Server 2008
  11. How can sanitation that escapes single quotes be defeated by SQL injection in SQL Server?
  12. How do I exclude Weekend days in a SQL Server query?
  13. Best data store for billions of rows
  14. newid() inside sql server function
  15. How do I list all tables in all databases in SQL Server in a single result set?
  16. How do I copy SQL Azure database to my local development server?
  17. Can you call a webservice from TSQL code?
  18. Comparing dates stored as varchar
  19. SQL Server: the maximum number of rows in table [closed]
  20. Retrieving date in sql server, CURRENT_TIMESTAMP vs GetDate()
  21. SQL Server 2008 Vertical data to Horizontal
  22. Joining multiple tables returns NULL value
  23. Which join syntax is better?
  24. How to maintain the order of insertion in SQL Server
  25. SQL Server query to find all current database names
  26. Data generators for SQL server? [closed]
  27. SQL Server Maximum rows that can be inserted in a single insert statment
  28. How do I connect to a SQL database from C#?
  29. sql geography to dbgeography?
  30. SQL Server 2008 – order by strings with number numerically

Leave a Comment