Table of Contents
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.