MS SQL Server - 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

This the response I got from TheMuffinMan:
Yes, Daniel....what happens is you have an offline database and it somehow
got the ID changed on it. You can make it "Online", or remove it via
query....or run an update on the sysdatabases table. I forgot the exact
command, so let me try to find it. Until then, try to run with the above and
let me know.

I used Query Analyzer to delete the offline databases, then everything came
back.
Hope that helps,
-Daniel

"KZeeh" wrote:
[color=darkred]
> I am also getting this same exact thing. Please tell me if you have found
> any resolution to this. I looked at the KB article mentioned about and it
> does not look like the GUEST or DBO accounts have been removed from any of
> the databases. I am at a loss. thanks for any help....
>
> "Daniel@tamc" wrote:
>

Sponsored Links