Line %d: Specified scale %d is invalid.

Error Message:
Msg 1002, Level 15, State 1, Line 3
Line %d: Specified scale %d is invalid.

Severity level:
15.

Description:
This error message appears when you try to specify an invalid value in a DECIMAL data type declaration.

Consequences:
The SQL statement cannot be parsed and further execution is stopped.

Resolution:
Error of the Severity level 15 are generated by the user and can be fixed by the SQL Server user. The specified scale value must be valid.

Versions:
This error messages was introduce with SQL Server 2005.

Example(s):
CREATE TABLE #t
(
 c1 DECIMAL(10,-1)
)

Remarks:
In the above example the provided scale value of -1 is not logical, invalid and therefore raises the error.




Related Articles :

  • No Related Articles Found

One Response to “Line %d: Specified scale %d is invalid.”

  1. NOT ENTIRELY TRUE!

    I am getting the same error, only the “scale” it specifies is the width of a TEXT field in Access! If I delete the text field with a width of 40 and try again it just gives me the width of another text field as the error. Eliminate that text field and it gives me another text field width as invalid (all less than 255)

Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |