Friday, March 23, 2012

How to make a enquiry for all database instances?

In SQl2000 i were abe to run an enquiry called "DATABASE $ALL" it was used to
enquiry all instance names on a SQL server for backup reasons, after
upgrading to SQL2005 this enquiry doesn't work.
Is there a new way to enquiry for all instance names in SQL2005?
Sr. System Engineer
Symantec
Hi Kennet
How are you running this enquiry? With T-SQL I would expect that you would
look at the sys.databases view. In SMO you have the databases member property
of the server object.
John
"Kennet Johansen" wrote:

> In SQl2000 i were abe to run an enquiry called "DATABASE $ALL" it was used to
> enquiry all instance names on a SQL server for backup reasons, after
> upgrading to SQL2005 this enquiry doesn't work.
> Is there a new way to enquiry for all instance names in SQL2005?
> --
> Sr. System Engineer
> Symantec

No comments:

Post a Comment