October 13, 2008 at 2:45 pm
Hi Guys,
How to write a query or script to list all the instances installed in a particular computer or machine ?
Is there any XP_CMDSHELL commands .............?
Plz answer it ASAP..
Thanks
AKP
October 13, 2008 at 3:21 pm
I don't know of a script, but just to be sure you know about these options for identifying instances, whether they are running or not...
1) In Administrative Tools/Services, you'll find your local SQL2000 instances under "MSSQL$instName" and your SQL2005 instances under "SQL Server(instName)."
2) From 2005 Management Studio, attempting to "Connect (to DB Engine)" will launch a "Connect to Server" screen. In the dropdown box for "Server name", you can choose "Browse for more...>". Expand the node under the "Local Servers" tab to see the instances on the local machine. The other tab is appropriately labeled "Network Servers."
3) If you have an instance of SQL2000 installed, you can still launch the sql mgr prgm (Program Files\Microsoft SQL Server\80\Tools\Binn\sqlmangr.exe) to see all of the 2000/2005 instances on the network.
October 13, 2008 at 3:58 pm
Actually I need to generate a report about All server names, All Dbs, IP address, All Instances and other server related informations. SO I need some scripting idea from where i can find out the installed instances in a particular server.
Thanks
AKP
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply