Home » how to pass parameter in sql server stored procedure

how to pass parameter in sql server stored procedure

sql server DBA 999

SQL Server Error : 131, Severity: 15. The size (%d) given to the %S_MSG ‘%.*ls

SQL Server Error : 131 Details

SQL Server Error: 131 Severity: 15 Event Logged or not: No Description: The size (%d) given to the %S_MSG ‘%.*ls’ exceeds the maximum allowed for any data type (%d). Severity 15 Description: Indicates syntax errors in the Transact-SQL command.

Error Description:

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.

On a Microsoft SQL Server database when we get the error “String or binary data would be … Read the rest