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

sql-server sql-server-express
Luke picture Luke · Sep 26, 2008 · Viewed 625.2k times · Source

I'm trying to determine what instances of sql server/sql express I have installed (either manually or programmatically) but all of the examples are telling me to run a SQL query to determine this which assumes I'm already connected to a particular instance.

Answer

George Mastros picture George Mastros · Sep 26, 2008

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'.

Related questions

SQL Server after update trigger

I have a problem with this trigger. I would like it to update the requested information only to the row in question (the one I just updated) and not the entire table. CREATE TRIGGER [dbo].[after_update] ON [dbo].[MYTABLE] …

Read More
SQL Server Express CREATE DATABASE permission denied in database 'master'

After I change the option as UserInstance="False", then the error starts to happen. Because I want to use full-text search, the option change is required. BUT, it stopped to work. Is there any way to make it work again? …

Read More
How can I do a BEFORE UPDATED trigger with sql server?

I'm using Sqlserver express and I can't do before updated trigger. There's a other way to do that?

Read More