Common Database Management Info

Hi,
I'm creating an application that will allow users to view information about
certain SQL Server instances and Databases.
Are there some system stored procs or tables where I can find the following
information.
Server Collation
Product Version e.g. 8.00
Product e.g. Standard Edition, Enterprise Edition
Database Names
Collation
Last DB BackUp
Size
Space Available
Owner
Recovery Model
No of Users
Thanksfor server information use
sp_server_info
For the database use it this way
sp_helpdb '<db name>'
Hope this helps.
-Omnibuzz (The SQL GC)
http://omnibuzz-sql.blogspot.com/
"Neil" wrote:

> Hi,
> I'm creating an application that will allow users to view information abou
t
> certain SQL Server instances and Databases.
> Are there some system stored procs or tables where I can find the followin
g
> information.
> Server Collation
> Product Version e.g. 8.00
> Product e.g. Standard Edition, Enterprise Edition
> Database Names
> Collation
> Last DB BackUp
> Size
> Space Available
> Owner
> Recovery Model
> No of Users
> Thanks
>