How to find the name of the physical server

Quite often I ask the question: “Which node is this instance running on right now?” – in a clustered environment. Or ‘What is the name of the physical server where this SQL Server instance is installed?’

Powered by Good Will. (Will is the person who offers his sympathy to others together with ideas, but who does not give any guarantee about the completeness of the concepts or the immaculate perfection of the scripts on this site. Use this site to grasp SQL Server concepts and to get knowledge. )