Question

Locked

ERROR_STATE() in SQL2005

By khanhmy264 ·
Anybody help me explain the description of the return-value from ERROR_STATE(). Thanks

ERROR_STATE(): Returns the state number of the error that caused the CATCH block of a TRY?CATCH construct to be run. BUT I would like to know the meaning or context which the returned-number stands for.


thanks for your help!


khanhmy

This conversation is currently closed to new comments.

1 total post (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Answers

Collapse -

As well as error_state

by Tony Hopkinson In reply to ERROR_STATE() in SQL2005

you can pick up error_text(), error_Number() and error_severity.

Just google error_state(), wodges of info on MSDN.

If you want to see the messages number, text, severity etc in 2005 use the view sys.messages, which is a friendly way of accessing the system table sysmessages.

Back to Software Forum
1 total post (Page 1 of 1)  

Related Discussions

Related Forums