January 22, 2003 at 8:35 am
Hi there everyone. Like many of you, I've spent a lot of time documenting our servers and SQL databases (as well as all the other systems). This has led me to develop an app that documents all the SQL Servers on a domain and produces a new SQL database containing the generated information. I have been working on a reporting tool to produce output from this database to MS Word and I hope to also create an ASP front end.
I was wondering if any of you had produced similiar software or if there are any available products that perform similar functions?
Nigel Moore
======================
January 22, 2003 at 9:36 am
Well I have been developing something more on a historical information store.
I have several SPs that run at each server collecting, DBInfo - size, inuse ..., TBInfo number of rows in each TB ..., Version info, I update a row when the SQL Version changes, JobSchedules shows when any automated jobs are run at each server, and I am working on JOB duration.
Then via replication, I transfer this info to a central repository for historical viewing, etc.
I have several other scripts I'm toying with, but I don't always have as much spare time as I would like.
I know NetIQ has a product that does some of this, I just started building it when I did have a bunch of free time, and have continued to add features when I have spare time.
KlK, MCSE
KlK
January 22, 2003 at 9:41 am
Thats the problem with everything now 'not enough spare time'.
If only there was a stored proc for that one!
Nigel Moore
======================
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply