SQL Server Performance

@@ServerName return NULL

Discussion in 'T-SQL Performance Tuning for Developers' started by jigar_pcs, Jun 23, 2005.

  1. jigar_pcs New Member

    Hi,
    I am facing a strange issue. I have a SQL server named ABC02 which is replacement server of ABC01. In order to preserve the name i want to change the name of ABC02 to ABC01 while i do the replcement.

    To accomplish that i used sp_addServer and sp_DropServer. When i checked sysservers the servername shows ABC01 now. when i execute ServerProperty ('ServerName') it returns ABC01 now but when i execute Select @@ServerName it returns NULL. Select @@ServerName was returning ABC02 before.

    I did restarted the SQL Server and machine as well still @@ServerName returns NULL.
    Any idea.



    Jigar Patel
  2. Luis Martin Moderator

    Kindly don´t duplicate post.



    Luis Martin
    Moderator
    SQL-Server-Performance.com

    One of the symptoms of an approaching nervous breakdown is the belief that one's work is terribly important
    Bertrand Russell


    All postings are provided “AS IS” with no warranties for accuracy.



  3. dineshasanka Moderator

    Try:
    Use Master
    go
    Select @@Servername

    This should return your current server name but if it
    returns NULL then try:

    Use Master
    go
    Sp_DropServer 'OldName'
    GO
    Use Master
    go
    Sp_Addserver 'NewName', 'local'
    GO
    Stop and Start SQL Services
  4. srinii New Member

    Hai ,this is srinivas. i have some doubts about PL/SQL.

    how to remove the Duplicate rows from table ?
    write query for start with name s and end with s??
    how to find highest and lowest sal of emp ??

    send querys for above??

    regards,
    srinivas
  5. ranjitjain New Member

    quote:Originally posted by srinii

    Hai ,this is srinivas. i have some doubts about PL/SQL.

    how to remove the Duplicate rows from table ?
    write query for start with name s and end with s??
    how to find highest and lowest sal of emp ??

    send querys for above??

    regards,
    srinivas

    Hi Srinivas,
    refer this link for all these type of interview questions.
    http://vyaskn.tripod.com/iq.htm[:)]
  6. Madhivanan Moderator

    Search in this Forum and you will find answers
    All the best for Interviews

    Madhivanan

    Failing to plan is Planning to fail
  7. Adriaan New Member

    <blockquote id="quote"><font size="1" face="Verdana, Arial, Helvetica" id="quote">quote:<hr height="1" noshade id="quote"><i>Originally posted by srinii</i><br /><br />Hai ,this is srinivas. i have some doubts about PL/SQL.<br /><br />how to remove the Duplicate rows from table ?<br />write query for start with name s and end with s??<br />how to find highest and lowest sal of emp ??<br /><br />send querys for above??<br /><br />regards,<br />srinivas<br /><hr height="1" noshade id="quote"></font id="quote"></blockquote id="quote">And perhaps search in Oracle resources for PL/SQL questions.[<img src='/community/emoticons/emotion-5.gif' alt=';)' />]<br /><br />And perhaps start a new thread instead of adding to an old, unrelated thread.[<img src='/community/emoticons/emotion-1.gif' alt=':)' />]

Share This Page