locked
What is what in this database setup?? RRS feed

  • Question

  • Hi All,

    I am very new to SQL Server.

    Please see below my connection to the database.

    >sqlcmd -H SRVDSM05015 -S sysdev7mssql,10507 -U appdbo -P appdbopwd
    1>
    2>
    3> select @@SERVERNAME
    4> go
    --------------------------------------------------------------------------------------
    SRVDSM05015\DON_DEV7_DEV
    (1 rows affected)
    1> select @@VERSION
    2> go
    ---------------------------------------------------------------------------------------
    ---------------------------------------------------------------------------------------
    Microsoft SQL Server  2000 - 8.00.2159 (Intel X86)
            Sep 15 2005 12:58:58
            Copyright (c) 1988-2003 Microsoft Corporation
            Enterprise Edition on Windows NT 5.0 (Build 2195: Service Pack 4)

    I can see that, SRVDSM05015 is the host machine where SQL Server software is installed, correct? But what is sysdev7mssql? what is 10507? and in @@SERVERNAME, what is DON_DEV7_DEV?

    Please explain.

    Thanks in advance

    Tuesday, July 31, 2012 3:06 PM

Answers

  • Would you please check-out 

    sqlcmd Utility


    Regards,
    Ahmed Ibrahim
    SQL Server Setup Team
    My Blog
    This posting is provided "AS IS" with no warranties, and confers no rights. Please remember to click "Mark as Answer" and "Vote as Helpful" on posts that help you.
    This can be beneficial to other community members reading the thread.

    Tuesday, July 31, 2012 6:28 PM

All replies

  • Hello,

    It seems you have a server named SRVDSM05015 with a SQL Server 2000 named instance installed. The name of that instance is DON_DEV7_DEV.

    Hope this helps.

    Regards,
    Alberto Morillo
    SQLCoffee.com

    Tuesday, July 31, 2012 3:45 PM
  • Thanks Alberto.

    What is "-S sysdev7mssql,10507" ? I am running this sqlcmd on my PC (not on the server).

    If I look at the help of sqlcmd, -S is server and -H is host. What is the difference? what is the number 10507 in there?

    Tuesday, July 31, 2012 4:43 PM
  • Hello,

    -S is to specify the instance name.

    10507 seems to be the port number used by that instance.

    Hope this helps.

    Regards,
    Alberto Morillo
    SQLCoffee.com

    Tuesday, July 31, 2012 5:47 PM
  • Would you please check-out 

    sqlcmd Utility


    Regards,
    Ahmed Ibrahim
    SQL Server Setup Team
    My Blog
    This posting is provided "AS IS" with no warranties, and confers no rights. Please remember to click "Mark as Answer" and "Vote as Helpful" on posts that help you.
    This can be beneficial to other community members reading the thread.

    Tuesday, July 31, 2012 6:28 PM