Post reply

@@servername return value is null???

  • December 29, 2003 at 1:23 am

    #64897

    Hi Guru,

    @@servername return value is null on SQL server. Any can tell me how to add the servername without reinstall the SQL server?

    Thanks in advance!

  • December 29, 2003 at 3:29 am

    #487906

    You can use the sp_addserver stored procedure, with the 'LOCAL' option.

    Look up sp_addserver in BOL.

    Cheers,

    - Mark


    Cheers,
    - Mark

  • December 30, 2003 at 3:05 am

    #488148

    Also see "renaming servers" as you are doing part of this.

    The SQL service will need restarted as well, BOL does not say this

  • December 30, 2003 at 9:28 pm

    #488326

    quote:

    Hi Guru,

    @@servername return value is null on SQL server. Any can tell me how to add the servername without reinstall the SQL server?

    Thanks in advance!

    Through T-Sql login with Windows Authontication -- in there "SP_AddServer @server = [new servername],@local = 'local'"

    Edited by - Subrahmanyam on 12/30/2003 9:35:04 PM

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

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