T-SQL Analyzer

# SQL Server Rule: SRP0004 | | | |----|----| | Assembly | SqlServer.Rules | | Namespace | SqlServer.Rules.Performance | | Class | AvoidReturningResultsFromTriggersRule | ## Rule Information | | | |----|----| | Id | SRP0004 | | Friendly Name | Noisy trigger | | Category | Performance | | Ignorable | true | | Applicable Types | Dml Trigger | ## Description Avoid returning results in triggers. ## Summary Avoid returning results in triggers. ### Remarks This rule scans triggers to ensure they do not send data back to the caller. Applications that modify tables or views with triggers do not necessarily expect results to be returned as part of the modification operation. For this reason it is not recommended to return results from within triggers. _{^{Generated by a tool}}