EM showing (No Items)

Having made no changes to the database server we are now getting no
database list when connecting via EM from client machines, as well as
locally on the database server. I've researched the problem to no
success. The database list shows up fine in QA, however. I used the
following script in QA:
use master
go
select * from sysdatabases
go
And this is the error message I received:
(36 row(s) affected)
Server: Msg 220, Level 16, State 1, Line 1
Arithmetic overflow error for data type smallint, value = 51805.
I saw a similar message when trying to delete an outdated Login
account.
Anyone have any ideas? Thanks in advance!
Jon Brookins
Paragon New Media, Inc.What version? Have you run DBCC CHECKDB recently?
"Jon Brookins" <jonathan@.pnmi.com> wrote in message
news:fa11c6b4.0310101200.58233742@.posting.google.com...
> Having made no changes to the database server we are now getting no
> database list when connecting via EM from client machines, as well as
> locally on the database server. I've researched the problem to no
> success. The database list shows up fine in QA, however. I used the
> following script in QA:
> use master
> go
> select * from sysdatabases
> go
> And this is the error message I received:
>
> (36 row(s) affected)
> Server: Msg 220, Level 16, State 1, Line 1
> Arithmetic overflow error for data type smallint, value = 51805.
> I saw a similar message when trying to delete an outdated Login
> account.
> Anyone have any ideas? Thanks in advance!
> Jon Brookins
> Paragon New Media, Inc.|||CHECKDB sounds like a good suggestion. Also, you might want to prepare yourself for restoring a
clean backup of the master database.
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as ugroup=microsoft.public.sqlserver
"Jon Brookins" <jonathan@.pnmi.com> wrote in message
news:fa11c6b4.0310101200.58233742@.posting.google.com...
> Having made no changes to the database server we are now getting no
> database list when connecting via EM from client machines, as well as
> locally on the database server. I've researched the problem to no
> success. The database list shows up fine in QA, however. I used the
> following script in QA:
> use master
> go
> select * from sysdatabases
> go
> And this is the error message I received:
>
> (36 row(s) affected)
> Server: Msg 220, Level 16, State 1, Line 1
> Arithmetic overflow error for data type smallint, value = 51805.
> I saw a similar message when trying to delete an outdated Login
> account.
> Anyone have any ideas? Thanks in advance!
> Jon Brookins
> Paragon New Media, Inc.