sunny.tjk (6/20/2016)
I'd like to run a query when the cluster node fails from node one node to the other.Can someone help me achieve this?
I somehow feel looking through the errorlog is the only solution.
Via TSQL
SELECT SERVERPROPERTY('ComputerNamePhysicalNETBios')
Via Powershell
Get-ClusterGroup "yourclustergroupname" | ft
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉