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

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.
LVL 1
humer2000Asked:
Who is Participating?
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
what service pack do you have on your SQL server itself?
I assume SP3?
0
 
humer2000Author Commented:
yes
0
 
humer2000Author Commented:
i am using version 8.00.760
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.