CODEWITHSUNDEEP
sql-servererror-handling
Jake
Jake

Reputation: 604

Where to find a custom error message in SQL Server?

Custom error message

I'm running a stored procedure in SQL Server and I'm getting the above error. I assume that this is a custom error because it is business-specific and also the word "because" is misspelled. But this text does not appear in the stored procedure text. Where can I find this error message so that I can determine why it is appearing?

Upvotes: 0

Views: 2043

Answers (1)

SkyCoder
SkyCoder

Reputation: 66

There is most likely a custom error message in the sys.messages table. Look for either the THROW or RAISERROR that is using a message id greater than 50000. That should tell you where the error is coming from and also you can correct the spelling mistake.

Upvotes: 5

Related Questions