For some reason, I have a problem remembering server name but don’t have any problem remembering SQL name instances. Maybe because I connect to the name instance more often then not. But when someone ask me what’s the physical servername of so and so SQL name instances, i’m lost.

a co-worker showed me a SQL function a few days ago that will tell you the physical servername of a SQL name instance:

select serverproperty(’ComputerNamePhysicalNetBIOS’)

I have to look around some more to see if this function will allow me to identify clustered nodes, be it active/active or active/passive.

Recent Entries

• C# - initialize a variable
• Return a status or value from sp_start_job
• iPhone 3G
• Creating Windows Clustered Resources
• changing sql services password
• sql 2005 connection error
• finding a bunch of server’s ip address
• finding physical servername
• order by asc for two (2) columns
• Finding filesizes

This entry was posted on Wednesday, March 18th, 2009 at 8:39 pm and is filed under sql. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.