METADATA - How to get the SERVER NAME on which an SP is Running

Question

Post reply

METADATA - How to get the SERVER NAME on which an SP is Running

sgmunson

SSC Guru

Points: 110640
More actions
July 31, 2008 at 12:25 pm

#382102

I'm hoping someone knows which system table or view I can query in a stored procedure to get the name of the server on which that sp is running. Anyone?
Steve
(aka smunson)
:):):)
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)

Viewing 3 posts - 1 through 2 (of 2 total)

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

Steve Jones - SSC Editor SSC Guru Points: 736632 More actions · Answer 1

Steve Jones - SSC Editor

SSC Guru

Points: 736632

July 31, 2008 at 12:32 pm

#851470

select @@servername

sgmunson SSC Guru Points: 110640 More actions · Answer 2

Wow... that was too easy... but thank you thank you thank you for saving me the time of having to try and find it when I wasn't even sure where in BOL to look !!!

Steve

(aka smunson)

Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)