Sessions: 102 The postings on this site are my own and do not represent my Employer's positions, advice or strategies.

LifeAsBob

  Thursday, March 28, 2024
Wider View Login

Cluster
DOS
IBM - AS400
MOM
Performance Counters
Service Broker
SQL Server
     Temporary Database
     Views
     Backup
     SQL Mail
     DTS - Data Transformation Services
     Memory
     Security
     Excel
     Jobs SQL Agent
     MSDE
     Install
     DBCC
     User Management
     System Databases
     BCV
     Deadlocks
     Temp Tables
     Find the physical se...
     Enable xp_cmdshell
     Intermittent Connect...
     Connection String Pr...
     Login Error ( State)...
     Turn Default Tracing...
     Re-index fails when ...
     SMO AND DMO
     Tracing of Errors
     Extra carriage Retur...
     Query to find Object...
     Named Instance Port ...
     Adding Domain Login ...
     Rename Logical File ...
     Error 3624 Delete st...
     SQL DMO Error 21776
     NetworkConnections
     SQL Server Service m...
     Trace Flags for Dead...
     Change Server Name
     Alternate to Count(*...
Windows OS




Will be added as a sub-category of, SQL Server
Find the physical server name.

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?’

So easy, found this great tip, this helps with clustered or virtual sql servers.

-- Physical server name on which the instance is running
SELECT  SERVERPROPERTY('ComputerNamePhysicalNetBIOS') AS ServerName

Source:

http://sqlconcept.com/2011/06/16/how-to-find-the-name-of-the-physical-server/