Error 2751

Severity Level 16

Message Text

Column or parameter #%d: -- specified column scale %d is greater than the specified precision of %d.

Explanation

This error occurs when the scale of a decimal or numeric column exceeds the precision value for that column.

For decimal and numeric datatypes, SQL Server normally supports a maximum precision of 28 digits for compatibility with various front ends. 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

Specify the precision with p, which must be between 1 and the maximum precision, and the scale with s, which must be between 0 and p. If you do not specify the precision, SQL Server uses a default precision of 18. If you do not specify the scale, SQL Server uses a default scale of 0.