Results 1 to 7 of 7
  1. #1
    Join Date
    Mar 2003
    Posts
    223

    Unanswered: How to check if sql sever running by DOS?

    Hello, all:

    I want to check if SQL Server and SQL Server Agent are running in a remote server by DOS command. IP address is available.

    Any suggestion will be great appreciated.

    ZYT
    ZYT

  2. #2
    Join Date
    Nov 2003
    Posts
    2,933
    Provided Answers: 12
    I'm curious why you are still using DOS?

    The tools from Sysinternals might help you, PSList will show running processes from a remote computer:

    http://technet.microsoft.com/en-us/sysinternals/bb896682.aspx

    But that won't run under DOS, you'll need at least Windows 2000 and some processes/services must be running on the target server to allow this.

  3. #3
    Join Date
    Jun 2004
    Location
    Long Island
    Posts
    696
    or (this will run under a command session)

    tasklist

    Tasklist

  4. #4
    Join Date
    Nov 2003
    Posts
    2,933
    Provided Answers: 12
    But tasklist cannot show processes from a remote computer

  5. #5
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,799
    Provided Answers: 11
    Why not just use OSQL to try to connect to the server?

  6. #6
    Join Date
    Jun 2004
    Location
    Long Island
    Posts
    696
    Syntax

    tasklist[.exe] [/s computer] [/u domain\user [/p password]] [/fo {TABLE|LIST|CSV}] [/nh] [/fi FilterName [/fi FilterName2 [ ... ]]] [/m [ModuleName] | /svc | /v]
    Top of page
    Parameters

    /s Computer : Specifies the name or IP address of a remote computer (do not use backslashes). The default is the local computer.

  7. #7
    Join Date
    Nov 2003
    Posts
    2,933
    Provided Answers: 12
    Blush

    I promise I read the online help more carefully next time...

Posting Permissions

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