February 18, 2008 at 11:08 pm
Is there any command(from Command line or SQL server) to list the sql server instances installed on the server?
Thanks,
Raj
February 19, 2008 at 3:17 am
I know there is a way to something similar from VB and C#
Visual Basic
Dim instance As System.Data.Sql.SqlDatSourceEnumerator = _
System.Data.Sql.SqlDataSourceEnumerator.Instance
C#
System.Data.Sql.SqlDataSourceEnumerator instance =
System.Data.Sql.SqlDataSourceEnumerator.Instance
Oraculum
February 19, 2008 at 3:23 am
The following command in cmd give the desired result.
OSQL -L (SQL Server 2000)
SQLCMD -L (SQL Server 2005)
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
February 19, 2008 at 4:02 am
In SQL Server 2005, you have a tool called, “SQL Server Configuration Manager”. You go there and click on SQL Server 2005 Services in left pane. Then it will display all the services including the instances on that particular machine.
Use SQL Server Service Manager if you have SQL Server 2000 installed.
Susantha
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply