I started off as a DBA almost 15 ago and never wanted to learn Business rules and write a line of development code. I felt at that time to be...

Guys..

Instead this will work to get the active node name on the cluster as well..!

select CONVERT(VARCHAR(10), SERVERPROPERTY('ComputerNamePhysicalNetBIOS'))

-VS

"there are 10 types of people in the world...those who understand binary and...