SQL SERVER – Fix : Error : Server: Msg 131, Level 15, State 3, Line 1 The size () given to the type ‘varchar’ exceeds the maximum allowed for any data type (8000)

Error:
Server: Msg 131, Level 15, State 3, Line 1 The size () given to the type ‘varchar’ exceeds the maximum allowed for any data type (8000)

When the the length is specified in declaring a VARCHAR variable or column, the maximum length allowed is still 8000.

Fix/WorkAround/Solution: Use either VARCHAR(8000) or VARCHAR(MAX) . VARCHAR(MAX) of SQL Server 2005 is replacement of TEXT of SQL Server 2000.

Reference : Pinal Dave (https://blog.sqlauthority.com)

SQL Error Messages, SQL String
Previous Post
SQL SERVER – Recompile All The Stored Procedure on Specific Table
Next Post
SQL SERVER – Explanation of WITH ENCRYPTION clause for Stored Procedure and User Defined Functions

Related Posts

Leave a Reply