Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
tocroi72
Yak Posting Veteran
89 Posts |
Posted - 2007-02-14 : 11:36:57
|
I expand the security on the SQL2000, right click on one of the login name to see the property of it and i got an error:Error 220: Arithmetic overflow error for data type smallint = 32802the statement has been terminated.I thought if i am running a query or writing some codes or trying to pass a numeric value that is too large for the datatype of smallint i would get this error, my case, i am not doing anything except right click on the login name (any login name) to see the property of it... why would i get this type of error? -Can any one help me how to solve this??? -Thanks... |
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2007-02-14 : 12:17:28
|
The largest value a smallint can hold is 32767CODO ERGO SUM |
|
|
mcrowley
Aged Yak Warrior
771 Posts |
Posted - 2007-02-14 : 12:47:11
|
Do you have thousands of logins or users? |
|
|
tocroi72
Yak Posting Veteran
89 Posts |
Posted - 2007-02-14 : 13:17:57
|
I only have about 15 logins. The problem is now i don't know how to find out which database/ or tables or column have that data type issue - I expand the database folders on Enterprise manager and i don't see any of database. I still can connect to the database using the query analyzer...how do i find the source of error? - PLEASE HELP.Thanks |
|
|
mcrowley
Aged Yak Warrior
771 Posts |
Posted - 2007-02-15 : 09:54:28
|
If this is just the one workstation experiencing this, you may just want ot uninstall and reinstall the SQL client (i.e. Enterprise Manager). |
|
|
|
|
|