I have a procedure in MS SQL, where front end receives a message whenever there is some error. RASIEERROR is truncating the message because the length is greater than 2048 chars. I also looked into Throw but it is also doing the same thing.
Links to refer:
- https://learn.microsoft.com/en-us/sql/t-sql/language-elements/throw-transact-sql?view=sql-server-ver15
- https://learn.microsoft.com/en-us/sql/t-sql/language-elements/raiserror-transact-sql?view=sql-server-ver15
Text from documentation
msg_str - Is a user-defined message with formatting similar to the printf function in the C standard library. The error message can have a maximum of 2,047 characters. If the message contains 2,048 or more characters, only the first 2,044 are displayed and an ellipsis is added to indicate that the message has been truncated.
Is there any way to increase the number of characters?