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.