Results 1 to 7 of 7
  1. #1
    Join Date
    Mar 2004
    Posts
    14

    Unanswered: How to know whether a computer is a Sql Server according to the name of computer?

    Thanks a lot

  2. #2
    Join Date
    Mar 2004
    Posts
    14

    remark: in sql statement

    remark: in sql statement

  3. #3
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    run this query:
    Code:
    select srvproduct from dbo.sysservers
    if it comes back with 'SQL Server' then you are on SQL Server
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  4. #4
    Join Date
    Feb 2004
    Location
    PAKISTAN
    Posts
    106
    SELECT SERVERPROPERTY('SERVERNAME')
    It would return the Instance name. If the output resembles with ur system-name; the SQL is the default instance. Othwerwise it would be a named instance, i.e., like :machine\instance

  5. #5
    Join Date
    Mar 2004
    Posts
    14

    Sorry,I mean how to know a computer is running sql server in a LAN.

    such as :
    you are on computer A that running a sql server,then you want to konw if computer B is running sql server.

  6. #6
    Join Date
    Apr 2004
    Location
    Kansas City, MO
    Posts
    734
    Download this tool from Microsoft:

    http://www.microsoft.com/downloads/d...DisplayLang=en

    It contains SQLScan, which will scan the LAN for all SQL Server installations.
    MeanOldDBA
    derrickleggett@hotmail.com
    When life gives you a lemon, fire the DBA.

  7. #7
    Join Date
    Sep 2003
    Location
    Memphis
    Posts
    62

    also

    If you have sql server, and you are interested:

    select @@version


    will give you the version information.


Posting Permissions

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