SQL Server Error : 123, Severity: 15. Batch/procedure exceeds maximum length o

SQL Server Error : 123 Details

SQL Server Error: 123
Severity: 15
Event Logged or not: No
Description:
Batch/procedure exceeds maximum length of %d characters.
Severity 15 Description:
Indicates syntax errors in the Transact-SQL command. The length of the variable or column value exceeds maximum allowed length.

Solution for Resolving the Error

Make Sure the number of characters length is matching that the char length of variable or column to value being inserted or trying to be updated.

 

For Example:

declare one varchar(10)

set one = ‘1234567891011’

SQL Server Error Code and solution summary

SQL Server Error: 123
Severity: 15
Event Logged or not: No
Description:
Batch/procedure exceeds maximum length of %d characters.

 

Make Sure the number of characters length is matching that the char length of variable or column to value being inserted or trying to be updated.