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
No comments:
Post a Comment