How to get a list of all the MS SQL Server instances on the local machine?

by

I am able to see both 2005 and 2008 SQL Server instances on my laptop using Powershell: 

Get-Service | Where-Object {$_.Name -like 'MSSQL$*'}

Other possibilities to explore include enumerating through the RegisteredServers namespace.

More Related Contents:

  1. How to make a query with group_concat in sql server [duplicate]
  2. Using merge..output to get mapping between source.id and target.id
  3. Column “invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause”
  4. Insert multiple rows WITHOUT repeating the “INSERT INTO …” part of the statement?
  5. Parameter Sniffing (or Spoofing) in SQL Server
  6. What are the main performance differences between varchar and nvarchar SQL Server data types?
  7. SQL Server String or binary data would be truncated
  8. How to change identity column values programmatically?
  9. SQL Server Regular expressions in T-SQL
  10. Concatenating Column Values into a Comma-Separated List
  11. List the queries running on SQL Server
  12. SQL Server pivot vs. multiple join
  13. SQL Server Bulk insert of CSV file with inconsistent quotes
  14. Real vs. Floating Point vs. Money
  15. SQL Server Query: Fast with Literal but Slow with Variable
  16. An attempt to login using SQL authentication failed
  17. Parse XML in SQL Server
  18. SQL Server 2008 – How do i return a User-Defined Table Type from a Table-Valued Function?
  19. Check if a string contains a substring in SQL Server 2005, using a stored procedure
  20. Why SQL Server DATETIME type saves time in ticks of 1/300 of a sec?
  21. Database design: Calculating the Account Balance
  22. migrate data from MS SQL to PostgreSQL?
  23. INFORMATION_SCHEMA vs sysobjects
  24. Does query plan optimizer works well with joined/filtered table-valued functions?
  25. In SQL Server, how can I find everywhere a column is referenced?
  26. Is there an “IF EXISTS” test for a linked server?
  27. Full text catalog/index search for %book%
  28. Why insert-select to variable table from XML variable so slow?
  29. Slow query with cfqueryparam searching on indexed column containing hashes
  30. How to avoid SSIS FTP task from failing when there are no files to download?

Leave a Comment