Exporting Database Properties to excel

Is there a way in sql server 2005 to export the database
properties( Right click on database-> Properties) to excel or some
other format?There's a way to export properties, but not via GUI. You can build a query
(or a set of queries) against the catalog views and some of the Dynamic
Management views to obtain the information you are interested of and use suc
h
queries in an SSIS package to export them in any format you like
Gilberto Zampatti
"haganahtrainer@.gmail.com" wrote:

> Is there a way in sql server 2005 to export the database
> properties( Right click on database-> Properties) to excel or some
> other format?
>|||On May 15, 10:35 pm, haganahtrai...@.gmail.com wrote:
> Is there a way in sql server 2005 to export the database
> properties( Right click on database-> Properties) to excel or some
> other format?
Look at sys.databases catalog view.
Regards
Amish Shah
http://shahamishm.tripod.com