Post reply

@@ServerName shows different value

  • February 19, 2015 at 11:14 am

    #315490

    Experts,

    Select @@Servername is showing 'GEBPC\GEBPC'

    where as the default sql instance shows 'GEBPC'

    how can this happen?

    please add your best intelligent guess here.

    this created an issue while creating a linked server from another server.

  • February 19, 2015 at 11:22 am

    #1778727

    Select @@Servername shows the instance you are connected to, not the default instance.


    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • February 19, 2015 at 12:03 pm

    #1778739

    I am connected to GEBPC

    but @@servername shows

    GEBPC\GEBPC

    when I connect first time , I use GEBPC only for the windows authentication.

  • February 19, 2015 at 12:38 pm

    #1778747

    Servername\instancename

    [font="Arial"]Low-hanging fruit picker and defender of the moggies[/font]

    For better assistance in answering your questions, please read this[/url].

    Understanding and using APPLY, (I)[/url] and (II)[/url] Paul White[/url]

    Hidden RBAR: Triangular Joins[/url] / The "Numbers" or "Tally" Table: What it is and how it replaces a loop[/url] Jeff Moden[/url]

  • February 19, 2015 at 1:03 pm

    #1778752

    that I know , please understand my question first:)

    Servername\instanceName

    if you look at the database server after you connect to GEBPC, you see GEBPC,

    not GEBPC\GEBPC.

    then I thought this is a default instance.

    HOWEVER , @@servername shows GEBPC\GEBPC , WHY?

    if it was an instance it should have shown like 'GEBPC\GEBPC'.

    moreover I should have connected to GEBPC\GEBPC

    or like

    http://www.codecandle.com/img/codecandle.img.topic101.r.bmssql2008.c2.SSMS.04.sql_instance.jpg

  • February 19, 2015 at 1:23 pm

    #1778754

    daniarchitect (2/19/2015)

    Experts,

    Select @@Servername is showing 'GEBPC\GEBPC'

    where as the default sql instance shows 'GEBPC'

    how can this happen?

    please add your best intelligent guess here.

    this created an issue while creating a linked server from another server.

    So, if I have this correct, you connect to GEBPC but when you run SELECT @@Servername it shows GEBPC\GEBPC?

    Do you have an alias configured?

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • February 19, 2015 at 2:24 pm

    #1778779

    Two possibilities here:

    1) The instance is GEBPC\GEBPC and it listens on port 1433. When you connect to GEBPC, you connect to the instance GEBPC\GEBPC. Or, as Perry says, a SQL Client alias is present.

    2) The instance name is wrong. Can happen sometimes, when you rename a computer with a SQL Server instance installed (or mess with sys.servers). Usually, the old computer name remains and doesn't change the instance name, but there's a remote possibility that you're facing this issue. Just to be sure, what does SERVERPROPERTY('ServerName') return? Same as @@SERVERNAME? If not, you may need to re-register your server. Details on how to do it can be found here: http://stackoverflow.com/questions/20992396/getting-wrong-server-name

    -- Gianluca Sartori

Viewing 7 posts - 1 through 6 (of 6 total)

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