SQL Server Performance

@@server

Discussion in 'SQL Server 2005 General DBA Questions' started by nupe02, Jun 27, 2007.

  1. nupe02 New Member

    @@server returns the server name But what table is this information is coming out of [?]
  2. satya Moderator

    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.
  3. MohammedU New Member

    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.
  4. satya Moderator

    [<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>

Share This Page