hostname - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Transact-SQL (2005)

hostname

Author

Topic

arkiboys
Master Smack Fu Yak Hacker

1433 Posts

Posted - 2008-07-17 : 10:03:30

Some sql server 2005 instances will be on a shared server. So for example, we may have 2 instances installed on a particular non-clustered SQL Server.
They will be for example: LNSQL100\INSTANCE1 LNSQL100\INSTANCE2 The server name in each case to direct the OS level calls will be: LNSQL100.
However, for Clusters, the instance naming and node convention will be different: LNVSQL100\INSTANCE1 LNVSQL100\INSTANCE2 on the node(s) LNCSQL100A or LNCSQL100B.
Seems like I need a reliable way to get the actual hostname from the instance name....
I have been looking at google search and the closest I have got to is fn_virtualservernodes(). It seems that this function does not do what I want.
Any thoughts please?

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2008-07-17 : 10:09:07

You still haven't found Books Online?
Try to find the information before asking for help for every little matter you have.
And there is a search functionality in this site, not to mention Google.

All these trivial questions about registry, OLE Automation and now host names, do you think you are your private army of personal problem solvers?

E 12°55'05.25"
N 56°04'39.16"

arkiboys
Master Smack Fu Yak Hacker

1433 Posts

Posted - 2008-07-17 : 10:11:24

Hi,
yes, Indeed I looked in google, please see my edited initial post regarding the function I found.
Thanks

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2008-07-17 : 10:13:48

You always write you didn't find the information, yet we have managed to provide solutions for you several times.

E 12°55'05.25"
N 56°04'39.16"

arkiboys
Master Smack Fu Yak Hacker

1433 Posts

Posted - 2008-07-17 : 10:15:52

Ok, thank you for your time.

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2008-07-17 : 10:21:07

Have you tried any of these?

SELECT	@@SERVERNAME,
	SERVERPROPERTY('ComputerNamePhysicalNetBIOS'),
	SERVERPROPERTY('InstanceName'),
	SERVERPROPERTY('MachineName'),
	SERVERPROPERTY('ServerName')

E 12°55'05.25"
N 56°04'39.16"

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2008-07-17 : 10:54:30

[code]SELECT *
FROM sys.dm_os_cluster_nodes [/code]

E 12°55'05.25"
N 56°04'39.16"

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2008-07-17 : 14:29:40

Not even a "Thank you"?

E 12°55'05.25"
N 56°04'39.16"

elancaster
A very urgent SQL Yakette

1208 Posts

Posted - 2008-07-17 : 14:31:15

maybe he'll 'try' and hack into your server and leave a personal thank you

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2008-07-17 : 14:35:31

I can only hope!

E 12°55'05.25"
N 56°04'39.16"

arkiboys
Master Smack Fu Yak Hacker

1433 Posts

Posted - 2008-07-17 : 15:02:33

Hi,
Many thanks for the information.
I should have mentioned that I have also tried SERVERPROPERTY('ComputerNamePhysicalNetBIOS')
But NOT
SELECT *
FROM sys.dm_os_cluster_nodes
This is what I want.

Thanks again for your time guys.

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2008-07-17 : 15:04:32

SELECT * FROM sys.dm_os_cluster_nodes is clearly accessible in Books Online and Google.

You're welcome.

E 12°55'05.25"
N 56°04'39.16"

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources