Error 2750

Troubleshooting SQL Server

Troubleshooting

Error 2750

Severity Level 16
Message Text

Column or parameter #%d: Specified column precision %d is greater than the maximum precision of %d.

Explanation

This error occurs when the precision of a float, decimal, or numeric column exceeds the maximum value for the specified data type.

For decimal and numeric data types, Microsoft® SQL Server™ normally supports a maximum precision of 38 digits for compatibility with various front ends, such as Microsoft Visual Basic®. For more information about running the sqlservr application, see sqlservr Application.

Action

Define the column to have a precision that falls within the allowable precision range for that data type.

See Also

decimal and numeric

float and real

Precision, Scale, and Length