T-SQL Analyzer

# SQL Server Rule: SRP0007 | | | |----|----| | Assembly | SqlServer.Rules | | Namespace | SqlServer.Rules.Performance | | Class | CursorNotClosedRule | ## Rule Information | | | |----|----| | Id | SRP0007 | | Friendly Name | Dangling cursor | | Category | Performance | | Ignorable | false | | Applicable Types | Procedure | | | Scalar Function | | | Table Valued Function | ## Description Local cursor not closed. ## Summary Local cursor not closed ### Remarks The rule checks if any local cursor is closed until the end of the batch. Because when open, the cursor still holds locks on referred-to-tables or views, you should explicitly close it as soon as it is no longer needed. _{^{Generated by a tool}}