SQL Server Performance Forum – Threads Archive
@@server
@@server returns the server name But what table is this information is coming out of [?]sys.SYSSERVERS system table Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.
quote:Originally posted by nupe02
@@server returns the server name But what table is this information is coming out of [?]
I believe you are asking about @@servername not @@server…It is better to user SERVERPROPERTY fucntion to get the server name instead of @@servername… because sometime you may get incorrect values when you rename the server…and did not drop and add the new server name…
MohammedU.
Moderator
SQL-Server-Performance.com All postings are provided “AS IS†with no warranties for accuracy.
[<img src=’/community/emoticons/emotion-1.gif’ alt=’
‘ />] There isn’t any @@server function, and remaining part of question where it is getting the values.<br /><br /><b>Satya SKJ</b><br />Microsoft SQL Server MVP<br />Writer, Contributing Editor & Moderator<br /<a target="_blank" href=http://www.SQL-Server-Performance.Com>http://www.SQL-Server-Performance.Com</a><br /><center><font color="teal"><font size="1">This posting is provided AS IS with no rights for the sake of <i>knowledge sharing. <hr noshade size="1">Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.</i></font id="size1"></font id="teal"></center>
]]>