
Signature
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
Thanks Hilary and Rodney
We've fixed it
http://www.mcse.ms/archive83-2005-5-1490199.html
and
http://groups.google.co.nz/group/microsoft.public.sqlserver.server/browse_thread
/thread/34a17fbf83c6d800/09f7325c72d4553f?lnk=st&q=odbc+sqlstate%3A+22003+error+
220%3A+arithmetic+overflow+error&rnum=2&hl=en#09f7325c72d4553f
We had 4 offline databases ready to be deleted sometime in the future,
brought them back online and all is sweet,
Thanks also to sql services
www.sqlservices.com
regards
Layth
> do they show up through isqlw/Query Analyzer?
>
[quoted text clipped - 15 lines]
> > Thanks and regards
> > Layth
Richard Fong - 25 Sep 2006 22:23 GMT
> Thanks Hilary and Rodney
> We've fixed it
[quoted text clipped - 29 lines]
> > > Thanks and regards
> > > Layth
Richard Fong - 25 Sep 2006 22:35 GMT
Hi Layth,
Just in case anybody else has this problem. Here is some more info on it.
The problem exists after the Windows SP4 install as it somehow corrupts the
database version in sysdatabases.
To fix this and determine if you have the same problem, execute the
following statement in master with Query Analyzer:
PROBLEM
==========
select * from sysdatabases
This should return something like (the value may differ):
Microsoft SQL-DMO (ODBC SQLState: 22003)
Error 220: Arithmetic overflow error for that data type smallint, value=32826.
Arithmetic overflow error for data type smallint, value=32826.
The statement has been terminated.
CAUSE
==========
An offline database had a version value of 32826 (or whatever you value is)
in the "version"
field, which is too large for a smallint datatype column in the
sysdatabases table.
RESOLUTION
============
It will fall over when it when it gets to the database with the incorrect
"version" and will NOT
show you the name of the database, so you will need to know the actual
name of the database. Keep in mind you CAN see the list of databases in
QA, but NOT the
problem database, so it's NOT the next one in the list when you run
the select query.
Once you identify your culprit. Run the Alter
database statement to set the database back online:
"ALTER DATABASE databasename SET ONLINE".
That should fix it.
Cheers
Richard
> Thanks Hilary and Rodney
> We've fixed it
[quoted text clipped - 29 lines]
> > > Thanks and regards
> > > Layth