How to find Active Sql Clustered Node using t-Sql

By Chaitanya Talasila on

Hi All,

Often we used to login into nodes, to find active clustered node for Sql server instance.

Run below query in Sql server instance query window.

SELECT SERVERPROPERTY(‘ComputerNamePhysicalNetBIOS’)

Its easy way to get the information.

Regards,

Chaitanya

Posted in: sql server

Leave a comment

Design a site like this with WordPress.com
Get started