March 6, 2003 at 1:44 am
How can I via TSQL find a list of ALL the instances /default version of sql server running on a machine?
March 6, 2003 at 4:50 am
It's early, so I'll risk foot-in-mouth and say you can't with a simple select. It's basically the same as saying 'find all the sql servers on the network'. You could use sp_oacreate to run dmo, it has a method that returns the names of published servers.
Andy
March 6, 2003 at 6:13 am
This might help...
http://www.sqlservercentral.com/scripts/contributions/711.asp
Cheers,
Crispin
Cheers,CrispinI can't die, there are too many people who still have to meet me!It's not a bug, SQL just misunderstood me!
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply