raise an error in sql server severity higher than 18
6
votes
2
answers
6955
views
I can easily raise user defined errors where severity is not higher than 18. When is higher, I get this error
> Error severity levels greater than 18 can only be specified by members of the
> sysadmin role, using the WITH LOG option.
I have access to sysadmin role, so can someone specify the syntax for raising errors WITH LOG option.
Thanks.
Asked by user159374
Aug 29, 2018, 06:29 AM
Last activity: Aug 29, 2018, 06:41 AM
Last activity: Aug 29, 2018, 06:41 AM