Error while accessing database tables

[awhitsel]

I am receiving an error while attempting to access the tables portion of one of my databases. Error text follows:

Title Bar: SQL Server Enterprise Manager
Error: [red circle with white "X"] Error 0: Numeric value out of range (with an OK button)

Does anyone know how to resolve this? Software fix?

Thanks.

 

[SQLBill]

I found two possibilities:

1. You have data in a numeric or decimal column that is greater than 32,767 or less than -32,768.

2. Your MDAC version needs upgraded.

What happens when you click OK?

(BTW-both possibilities were from Microsoft's website).

You might try just upgrading your MDAC version to 2.8 (the latest). And then retrying it.

-SQLBill

 

[bertrandkis]

You get this error when you enter a value that exceeds the field size because Each data type has limitations.Check this:
Data type:bigint
Integer (whole number) data from -2^63 (-9223372036854775808) through 2^63-1 (9223372036854775807).

Data type:int
Integer (whole number) data from -2^31 (-2,147,483,648) through 2^31 - 1 (2,147,483,647).

Data type:smallint
Integer data from 2^15 (-32,768) through 2^15 - 1 (32,767).

Data type:tinyint
Integer data from 0 through 255.

So if you enter the value 1000 in a field defined as Tinyint, you will certainly get that error.
Check your fields data types.

Bertrandkis
SQL Wizard

 

[awhitsel]

An update on this situation:

One of my co-workers got this same error. She is now able to access the tables, however, I am still receiving the error.

I also receive the error when accessing the Permissions tab for the database properties. After that, I receive an error stating that it could not get property information for the affected database and shuts down the properties window.

 

[awhitsel]

Another update:

My co-worker is getting the out of range error again.