Arithmetic overflow error - sql2k

Hi,
When I open the table from sqlem and update a field, it give me the error
says,
Arithmetic overflow error for data type tinyint, value = -1.
The statement has been terminated.
Any idaes?
ThamksI would suspect data corruption and run DBCC CHECKDB. OR possibly this error is generated from a
trigger so you want to check if there are any triggers on the table. The first thing you want to do,
though is to see if you get the same error from an UPDATE statement; so we can rule out possible
problems in EM.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"mecn" <mecn2002@.yahoo.com> wrote in message news:%238xdNyInHHA.4772@.TK2MSFTNGP05.phx.gbl...
> Hi,
> When I open the table from sqlem and update a field, it give me the error says,
> Arithmetic overflow error for data type tinyint, value = -1.
> The statement has been terminated.
> Any idaes?
> Thamks
>|||How about the limitation of a tinyint that it be between 1 and 255' Check
BOL for datatype ranges.
--
TheSQLGuru
President
Indicium Resources, Inc.
"mecn" <mecn2002@.yahoo.com> wrote in message
news:%238xdNyInHHA.4772@.TK2MSFTNGP05.phx.gbl...
> Hi,
> When I open the table from sqlem and update a field, it give me the error
> says,
> Arithmetic overflow error for data type tinyint, value = -1.
> The statement has been terminated.
> Any idaes?
> Thamks
>|||I wasn't even considering that mecn might be trying to input a negative value.
Mecn, if that is the case then you can ignore my post.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"TheSQLGuru" <kgboles@.earthlink.net> wrote in message news:udmkA3JnHHA.4516@.TK2MSFTNGP05.phx.gbl...
> How about the limitation of a tinyint that it be between 1 and 255' Check BOL for datatype
> ranges.
> --
> TheSQLGuru
> President
> Indicium Resources, Inc.
> "mecn" <mecn2002@.yahoo.com> wrote in message news:%238xdNyInHHA.4772@.TK2MSFTNGP05.phx.gbl...
>> Hi,
>> When I open the table from sqlem and update a field, it give me the error says,
>> Arithmetic overflow error for data type tinyint, value = -1.
>> The statement has been terminated.
>> Any idaes?
>> Thamks
>>
>|||TheSQLGuru,
I know you meant between 0 and 255.
AMB
"TheSQLGuru" wrote:
> How about the limitation of a tinyint that it be between 1 and 255' Check
> BOL for datatype ranges.
> --
> TheSQLGuru
> President
> Indicium Resources, Inc.
> "mecn" <mecn2002@.yahoo.com> wrote in message
> news:%238xdNyInHHA.4772@.TK2MSFTNGP05.phx.gbl...
> > Hi,
> > When I open the table from sqlem and update a field, it give me the error
> > says,
> >
> > Arithmetic overflow error for data type tinyint, value = -1.
> > The statement has been terminated.
> >
> > Any idaes?
> >
> > Thamks
> >
> >
>
>