SQL TOOLS

  • Hi all,does anyone know of a free SQL tool that can scan a group of machines and expose the follwoing:

    1.What version of SQL on each machine.

    2.Service pack level

    3.Number of databases on each SQL machine.

    Thanks.

  • You can do this with a local server group in SSMS and a query such as this

    SELECT @@VERSION,COUNT(*) As NumberOfDatabases FROM sys.databases

    Have a look here

    http://www.sqlservercentral.com/articles/Management+Studio+(SSMS)/63650/

    ____________________________________________________

    Deja View - The strange feeling that somewhere, sometime you've optimised this query before

    How to get the best help on a forum

    http://www.sqlservercentral.com/articles/Best+Practices/61537
  • have a look at the MAP toolkit, it should give you 1,2 not sure about 3 though.

    http://technet.microsoft.com/en-us/library/bb977556.aspx%5B/url%5D

  • SSIS isn't free, but it comes with the product, so it won't cost you anything extra to write a package that will connect to each server and get the information you're looking for. That will involve a little work on your part, so if you're not comfortable or confident with SSIS, you might want to investigate a utility called sqlping. I've never used it so I don't know how much of the information you require it will give you, but you can use the data it does return to connect to each server in turn and get the rest of the information.

    John

  • I think you can do this thorugh Powershell

  • davidshephard (11/9/2011)


    Hi all,does anyone know of a free SQL tool that can scan a group of machines and expose the follwoing:

    1.What version of SQL on each machine.

    2.Service pack level

    3.Number of databases on each SQL machine.

    Thanks.

    SQLRecon or SQLPing can give you #1 and #2, but you'll probably need to use powershell to get #3. so if you are going to use powershell, i'd do all the data gathering there instead.

    Lowell


    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • Thanks a ton.

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

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