Home Dashboard Directory Help

RaiseError Severity Levels by sfibich


 as Fixed Help for as Fixed

Sign in
to vote
Type: Suggestion
ID: 660729
Opened: 4/13/2011 8:21:26 AM
Access Restriction: Public


SQL Server 2008 Books Online does not mention that if you pass a -1 to the RaiseError call that it uses the severity level in the sysmessages table by default. Can this be included in the documentation in future releases and is this something that can be counted on as a feature in the future?
Sign in to post a comment.
Posted by DbaiG on 9/3/2013 at 2:46 AM
Wow, this is really helpful way of dealing with errors. It is good to see that customer complains are being properly attended to. I think it is crucial in tech world as user gets very disappointed if application is not working properly. Providing tech support is really crucial to get an edge in rapidly changing digital world.

Posted by Microsoft on 8/12/2013 at 5:17 PM
Sorry about the delay in fixing this. It is true that you can use -1 for both the severity and state parameters to return the default values associated with the given error. I've updated the RAISERROR topic for SQL Server 2012 to reflect this. The topic will be published between 8/13/2013 and 8/20/2013.
Posted by Microsoft on 4/18/2011 at 9:13 AM
Thank you for reporting this behavior. We will investigate and update the 2008R2 documentation as appropriate in a future update to Books Online.

Kind Regards,
Gail Erickson
SQL Server Documentation team
Sign in to post a workaround.
Posted by nanc79 on 9/4/2013 at 8:15 PM
Dsn=MS Access Database