Results 1 to 3 of 3

Thread: @@SERVERNAME

  1. #1
    Vivek Amin Guest

    @@SERVERNAME

    I am getting a null value when i am query the Global variable @@servername.

    Please help !!
    Thanks
    vIVEk.

  2. #2
    Murali Guest

    @@SERVERNAME (reply)

    Vivek,

    Use the following system stored procedure to define the name of the SQL Server.

    sp_addserver servername[, LOCAL]

    *But don`t forget to re-start your SQL Server to see the result.

    `LOCAL` parameter sets the value of the global variable @@SERVERNAME



    On 7/13/98 6:01:56 PM, Vivek Amin wrote:
    > I am getting a null value when i am query the Global variable
    > @@servername.

    Please help !!
    Thanks
    vIVEk.

  3. #3
    Vivek Amin Guest

    @@SERVERNAME (reply)

    Thanks for the prompt reply
    I already did that, still i am getting a NULL value

    vIVEk

    On 7/14/98 2:33:57 PM, Murali wrote:
    > Vivek,

    Use the following system stored procedure to define the name of
    > the SQL Server.

    sp_addserver servername[, LOCAL]

    *But don`t forget to
    > re-start your SQL Server to see the result.

    `LOCAL` parameter sets the
    > value of the global variable @@SERVERNAME



    On 7/13/98 6:01:56 PM,
    > Vivek Amin wrote:
    > I am getting a null value when i am query the Global
    > variable
    > @@servername.

    Please help !!
    Thanks
    vIVEk.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •