Windows server name from T-sql

Question

Viewing 9 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply

guarddata SSCertifiable Points: 6583 More actions · Answer 1

For clarification - I assume this means that @@servername returns the cluster name instead of the server name?

Guarddata-

kbeech SSC-Addicted Points: 420 More actions · Answer 2

Yes @@servername does return the Cluster's name and not the Servers name.

Steve Jones - SSC Editor SSC Guru Points: 736280 More actions · Answer 3

Are you looking for which server is active? Because the cluster'd server isn't "on" a machine. That's the idea.

Steve Jones

kbeech SSC-Addicted Points: 420 More actions · Answer 4

I am looking for what severs are controlling the active clusters.

kbeech SSC-Addicted Points: 420 More actions · Answer 5

I am looking for what severs are controlling the active clusters.

Johan Bijnens SSC Guru Points: 135369 More actions · Answer 6

are you lookig for xp_cmdshell 'net name' ?

Johan

Learn to play, play to learn !

Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:

- How to post Performance Problems
- How to post data/code to get the best help[/url]

press F1 for solution, press shift+F1 for urgent solution 😀

Need a bit of Powershell? How about this

Johan Bijnens SSC Guru Points: 135369 More actions · Answer 7

Maybe this can get you on tracke:

CREATE TABLE #tInfo (SQLServerComputerName nvarchar(500))

insert into #tInfo (SQLServerComputerName)

exec xp_cmdshell 'net name'

select SQLServerComputerName from #tInfo

drop table #tInfo

Don't open your cmdshell for non-sysadmins for this reason, but only execute it when logged in as sysadmin.

Edited by - alzdba on 08/26/2003 01:10:26 AM

Johan

Learn to play, play to learn !

Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:

- How to post Performance Problems
- How to post data/code to get the best help[/url]

press F1 for solution, press shift+F1 for urgent solution 😀

Need a bit of Powershell? How about this

kbeech SSC-Addicted Points: 420 More actions · Answer 8

Thanks alzdba xp_cmdshell 'net name' works for me