I need a sql server script for my notification for the following.
I have node 1 and node 2 in my clustered environment.
Instances 1 and 2 usually runs on node 1. Instance 2 usually on node 2.
Sometimes they switch without notification. I need to know when they switch. Because I copy files from instances.
Need to know only what instance changed from which node and vice versa.
Any ideas and answers would be greatly appreciated.
View Complete Post