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?
>
Sunday, March 25, 2012
Exporting Database Properties to excel
Labels:
click,
database,
database-gt,
databaseproperties,
excel,
export,
exporting,
microsoft,
mysql,
oracle,
properties,
server,
someother,
sql
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment