CODEWITHSUNDEEP
sql-server
benjamin moskovits
benjamin moskovits

Reputation: 5458

How can I check for existence of an error number?

Is there a way to check if an error number (over 50000) already has been added? I know I can try adding a message and get a 15043 if I re-add an existing message.

Upvotes: 0

Views: 45

Answers (1)

HoneyBadger
HoneyBadger

Reputation: 15150

All error messages (system and user defined) are viewable in the system view sys.messages.

Upvotes: 1

Related Questions