Hi, I am in the process of migrating from NetIQ V6 to MOM2005 SP1. We use proprietary client software writing thousands of transactions to our SQL servers every minute. All SQL servers are clustered running multiple instances of SQL. My problem is that we use custom scripts to check data integrity, consistency and for data irregularities. Now with NetIQ we could use their com objects to get the instance name that is currently running on a node and parse this into our VB script connection string to run stored procedures. Based on record sets returned we can then either raise an event of simply log the data returned. The vb logic for this in MOM2005 is the same (using scriptcontext) except I can’t find a simple way to dynamically get the full sql instance name for the ADO connection string (using wmi, mom functions etc) Any help would be much appreciated Thanks Gary
