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)