Msg 131, Level 15, State 2, Line 3
The size (%d) given to the %S_MSG ‘%.*ls’ exceeds the maximum allowed for any data type (%d).
This error message appears when you try to specify a size for a column that exceeds the maximum allowed size for any data type.
The SQL statement cannot be parsed and further execution is stopped.
Error of the Severity level 15 are generated by the user and can be fixed by the SQL Server user. The size must be within the allowed range.
All versions of SQL Server.
IF OBJECT_ID(‘tempdb..#t’) > 0
DROP TABLE #t
CREATE TABLE #t
In the above example we try to create a column of type CHAR with a size of 8001. This is beyond the allowed size and raises the error.