Results 1 to 4 of 4
  1. #1
    Join Date
    Dec 2003
    Posts
    3

    Unanswered: Find all instances of MS SQL

    How can I find all instances of MS SQL running in my organization? My task to is to audit all instances and stop unautorised or unlicensed instances.

    Any help will be appreciated.
    Thanks,

  2. #2
    Join Date
    Dec 2003
    Posts
    4

    Re: Find all instances of MS SQL

    Originally posted by azam7
    How can I find all instances of MS SQL running in my organization? My task to is to audit all instances and stop unautorised or unlicensed instances.

    Any help will be appreciated.
    Thanks,

    You can use OSQL with the -L switch to list servers on you network. I don't know off hand if it will list any across subnets, etc. The command is: isql -L


    Mike

  3. #3
    Join Date
    Feb 2002
    Posts
    2,232
    From what I remember it will only list sql servers within that domain - even then it may not be complete.

  4. #4
    Join Date
    Dec 2003
    Posts
    3
    Thanks a lot guys...isql -l works
    :-)

Posting Permissions

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