T-SQL Analyzer

# SQL Server Rule: SRD0044 | | | |----|----| | Assembly | SqlServer.Rules | | Namespace | SqlServer.Rules.Design | | Class | RaiseErrorWithoutLogRule | ## Rule Information | | | |----|----| | Id | SRD0044 | | Friendly Name | Error handling requires SA permissions | | Category | Design | | Ignorable | false | | Applicable Types | Procedure | | | Scalar Function | | | Table Valued Function | ## Description The RAISERROR statement with severity above 18 requires the WITH LOG clause. ## Summary The RAISERROR statement with severity above 18 and requires WITH LOG clause. ### Remarks The rule checks RAISERROR statements for having severity above 18 and not having a <c>WITH LOG</c> clause. Error severity levels greater than 18 can only be specified by members of the sysadmin role, using the WITH LOG option. Severity levels from 0 through 18 can be specified by any user. Severity levels from 19 through 25 can only be specified by members of the sysadmin fixed server role or users with <c>ALTER TRACE</c> permissions. For severity levels from 19 through 25, the <c>WITH LOG</c> option is required. _{^{Generated by a tool}}