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 such
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?
>

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