J,

Can you provide us the column list of the spreadsheet system you currently are using?

In my environment, I use a mix of built-in procedures like sp_helpdb and the custom script (as well as others) that I posted above to populate 2 Excel spreadsheets. One tracks at the server/instance level, and the second one at the database level.

Each document gets a review at least once a month, or when a new database server is being brought online, when a new SQL patch is released. etc.

These spreadsheets come in real handy when my boss gives asks me to get him numbers for his next meeting (oh yeah, it is in 5 minutes) and wants a count of how many SQL 2000 instances we have on Windows 2003 or how many SQL Server 2005 databases we have currently running on SQL Server Service Pack 2.

I would be interested in comparing the information I track with you as well as others.