• Might I suggest Rodney Landrum's SQL Tacklebox located here:

    http://www.red-gate.com/community/books/sql-server-tacklebox

    He includes a boatload of scripts - downloadable as a zip file - for documenting and monitoring SQL Server instances using T-SQL and SSIS. At the very least it will give you a handle on what you've got running loose in your shop. And you can't beat the price!

    ____________
    Just my $0.02 from over here in the cheap seats of the peanut gallery - please adjust for inflation and/or your local currency.