Friday, March 30, 2012

Instances

How to see the no of instances created for my server.

if it is sql server 2005

sqlcmd -L : it will list all the instances in the network , you can identify by machine name what all the instance in your machine

for SQL 2000

osql -L

|||yes. They give the list of sql servers in the list.
But what i want is
the instances created for my server only.|||

Launch the services console: services.msc - it should list a separate SQL Server service for each instance.

You can also check the registry: HKLM\Microsoft SQL Server\Instance Names.

Thanks
Laurentiu

sql

No comments:

Post a Comment