August 12, 2004 at 10:37 am
We will be offering application hosting where one machine will have multiple instances of SQL. Is there a program or utility that will allow me to connect to all instances on a single machine and determine if there are current connections?
Thanks,
Dave
August 13, 2004 at 12:08 pm
I am not sure about specific utility for this reason but you can connect to all those instances from SQL-EM. Then it is easy to manage each at a time.
All you need is that under SQL Server Group on your machine, register the new SQL-Server instance. Does it satisfy your need?
August 13, 2004 at 12:29 pm
Thanks. With this approach I'll have to log into each instance and then go to each Current Activity to determine who or how many are in the system.
Still looking...
Thanks again,
Dave
August 13, 2004 at 1:05 pm
August 18, 2004 at 9:36 am
IT would not be difficult to use SQL-DMO to iterate throught each of the instances and run sp_who or sp_who2 then display ther results on a web page or in an application.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply