SQL Server Performance Forum – Threads Archive
Instances
Hi All, How to know how many instances of my sql server has been running in the network. Thanksias
In sql server 2005 open command prompt and run Sqlcmd -L. it will give u the list of sql serveri nstance in the network. see your machine name and the instances sql 2000 open command prompt and run osql -L Madhu
Keep in mind it will not detect 64-bit sql2005 instances (buggy sqlbrowser)
quote:Originally posted by alzdba
Keep in mind it will not detect 64-bit sql2005 instances (buggy sqlbrowser)
No.. there is no such problem in SQLCMD. i can find both 64 and 32 server in my network. and also i checked in the documentation , it is not mentioned. Madhu
It is not mentioned in any documentation, but still on few x64 based instances this is a problem due to that instance is set to visible on network, by default it will try to findout but you might not get as suggested by Alzdba. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.
]]>