Home > Archive > MS SQL Server > March 2005 > Re: Enterprise Manager Databases









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author Re: Enterprise Manager Databases
Daniel@tamc

2005-03-31, 8:01 pm

I used query analyzer to query MASTER database, sysdatabases table.
See this for more info:
http://msdn.microsoft.com/library/d..._sys-d_5xrn.asp

Status field bits=512 indicates offline.

"KZeeh" wrote:
[color=darkred]
> OK, but how do I determine if a database is offline? I don't know where to
> see that. Thanks.
>
> "Daniel@tamc" wrote:
>
Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2008 droptable.com