Can't view databases in SEM, Error 220, Arithmetic overflow

humer2000
humer2000 used Ask the Experts™
on
Hi Experrts

Everything was working fine until yesterday.
When i connect to the SQL server via SEM and expands the databases list it displays (No Items).

It happens to me as well and I connect as SA.
When i go to Security / Logins, if i double click on any user, including SA, i get the same error.

When any connects via Query Analyzer they can view the databases just fine.

When I execute:

SELECT * FROM SYSDATABASES in the master database of this server I get:

(25 row(s) affected)
Server: Msg 220, Level 16, State 1, Line 1

This is on SQL Server 2000 running SP2 Windows 2003 server.

Note: i have changed one week ago SA password via QueryAnalyser.

Any ideas are greatly appreciated.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Guy Hengel [angelIII / a3]Billing Engineer
Most Valuable Expert 2014
Top Expert 2009

Commented:
what service pack do you have on your SQL server itself?
I assume SP3?

Author

Commented:
yes

Author

Commented:
i am using version 8.00.760
Billing Engineer
Most Valuable Expert 2014
Top Expert 2009
Commented:

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial