Can't view databases in SEM, Error 220, Arithmetic overflow
Posted on 2007-04-10
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.