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 datatype.

For decimal and numeric datatypes, SQL Server normally supports a maximum precision of 28 digits for compatibility with various front ends, such as Microsoft Visual Basic. However, if a precision greater than 28 is desired, use the /p parameter with sqlservr.exe from a Win32 command prompt. For more information on running sqlservr.exe, see the Utilities topic in the Microsoft SQL Server Transact-SQL Reference.

Action

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