|
Posted by joe_acme on 11/27/06 19:14
Do a select from the sysdatabases table in the master database. All
the database property information is there. You may need to look up
sysdatabases in Books Online to interpret the status column.
Joe
Guvnor wrote:
> Hello there,
>
> I have about 30 sql servers runnign multiple databases amd i need to
> audit them so what i want to do is to log onto each server and then
> maybe export the database properties into an excel sheet or text file.
>
> Anyone know how to do that i am quite new to sql any help will be
> awesome.
>
> Regards and thanx in advance
Navigation:
[Reply to this message]
|