Sample Header Ad - 728x90

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