Code Analysis

PE016

Page last updated 05 February 2021

Cursor is opened but is not deallocated

It is recommended to deallocate a cursor explicitly.

Available in

 SQL Monitor

SQL Prompt

 SQL Code Guard


This documentation contains proprietary information and is protected by copyright law.
Copyright © 2026 Red Gate Software Limited. All rights reserved

Didn't find what you were looking for?

Product Articles

Tips and how-to guides for Redgate products

University

Easy to follow video courses

Community Forums

Ask, discuss, and solve questions about Redgate's tools

Events & Friends

Meet us at an event, get sponsored, and join our Friends of Redgate

Simple Talk

In-depth articles and opinion from Redgate's technical journal