I'm sure there must be a way to do this but does anyone know of a query
(or several) that can be used to get basic "system" information about a
particular SQL instance and also on a particular database? I'm looking
for stuff like:

Server stats:
- SQL Product Name
- OS
- SQL Version
- Memory (total on box, and in-use)
- Root directory

Database stats:
- Last backup date
- Database status
- Size
- Path to Primary and Log files

Ultimately I'll use some of this to derive other info:
- HD space available on SQL root
- HD space available on drive hosting database Primary and Log


Thanks much!!

Ken

MS Sql Server LazyDBA home page