Enterprise Manager Databases

When I try to look at my databases in Enterprise Manager it says (no items)
under the databases heading. I have tried re-registering the server and I
have tried it on several systems including from the server. I am connecting
with administrative access to the server.
The databases seem fine, I can see them all through query analyser and
through a web interface.
Anyone out there know how to get my database list back?
Thanks
do you see any kind of error in the errorlog such as exceptions? If so,
did you remove guest account, there might be a problem.
http://support.microsoft.com/default...b;en-us;315523
Yih-Yoon Lee
My blog http://www.mssql-tools.com/blog
E-mail: yihyoon.online@.gmail.com
/* remove .online to send me e-mail */
Dirk Marshall wrote:
> When I try to look at my databases in Enterprise Manager it says (no items)
> under the databases heading. I have tried re-registering the server and I
> have tried it on several systems including from the server. I am connecting
> with administrative access to the server.
> The databases seem fine, I can see them all through query analyser and
> through a web interface.
> Anyone out there know how to get my database list back?
> Thanks
|||I have a similar issue. I'm not getting any errors...the databases, jobs
are not showing up either on my Enterpise Manager on my laptop or on the
server itself. However, I can see them in Query Analyizer, BUT when I try to
edit a stored proc, I get some wierd error:
[Microsoft][ODBC SQL Server Driver][SQL Server]Arithmetic overflow error for
data type smallint, value = 32867.
[Microsoft][ODBC SQL Server Driver][SQL Server]Arithmetic overflow error for
data type smallint, value = 32867.
[Microsoft][ODBC SQL Server Driver][SQL Server]The statement has been
terminated.
Bummer...
"Yih-Yoon Lee" wrote:

> do you see any kind of error in the errorlog such as exceptions? If so,
> did you remove guest account, there might be a problem.
> http://support.microsoft.com/default...b;en-us;315523
> Yih-Yoon Lee
> My blog http://www.mssql-tools.com/blog
> E-mail: yihyoon.online@.gmail.com
> /* remove .online to send me e-mail */
> Dirk Marshall wrote:
>
|||I get the same thing as well. Only change I made recently was the install
some recent MS security patches, but none that related to SQL server. Have
you found out anything new on this?
"TheMuffinMan" wrote:
[vbcol=seagreen]
> I have a similar issue. I'm not getting any errors...the databases, jobs
> are not showing up either on my Enterpise Manager on my laptop or on the
> server itself. However, I can see them in Query Analyizer, BUT when I try to
> edit a stored proc, I get some wierd error:
> [Microsoft][ODBC SQL Server Driver][SQL Server]Arithmetic overflow error for
> data type smallint, value = 32867.
> [Microsoft][ODBC SQL Server Driver][SQL Server]Arithmetic overflow error for
> data type smallint, value = 32867.
> [Microsoft][ODBC SQL Server Driver][SQL Server]The statement has been
> terminated.
> Bummer...
> "Yih-Yoon Lee" wrote:
|||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:
[vbcol=seagreen]
> I get the same thing as well. Only change I made recently was the install
> some recent MS security patches, but none that related to SQL server. Have
> you found out anything new on this?
> "TheMuffinMan" wrote:
|||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:
[vbcol=seagreen]
> 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:
|||OK, but how do I determine if a database is offline? I don't know where to
see that. Thanks.
"Daniel@.tamc" wrote:
[vbcol=seagreen]
> 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:
|||I used query analyzer to query MASTER database, sysdatabases table.
See this for more info:
http://msdn.microsoft.com/library/de...sys-d_5xrn.asp
Status field bits=512 indicates offline.
"KZeeh" wrote:
[vbcol=seagreen]
> OK, but how do I determine if a database is offline? I don't know where to
> see that. Thanks.
> "Daniel@.tamc" wrote:
|||Of course, none of mine have a status of 512, it is a combination of bits.
I've got a lot of 1552's, which I think is 1024(readonly) + 512(offline) +
16(torn page detection). Then I also have a lot of 28s too. I am just not
sure what to "reset" these numbers to. Is there a more comprehensive list
anywhere about resetting the status? Thanks so much for helping me out with
this. I couldn't find any info anywhere on this...
"Daniel@.tamc" wrote:
[vbcol=seagreen]
> I used query analyzer to query MASTER database, sysdatabases table.
> See this for more info:
> http://msdn.microsoft.com/library/de...sys-d_5xrn.asp
> Status field bits=512 indicates offline.
> "KZeeh" wrote:
|||SELECT name, DATABASEPROPERTY(name, 'IsOffLine') AS OffLine
FROM sysdatabases
1 means offline.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"KZeeh" <KZeeh@.discussions.microsoft.com> wrote in message
news:727DEAE3-1F12-4A71-A12B-BA38908CA919@.microsoft.com...[vbcol=seagreen]
> OK, but how do I determine if a database is offline? I don't know where to
> see that. Thanks.
> "Daniel@.tamc" wrote: