sp-cursorunprepare-transact-sql.md

title	sp_cursorunprepare (Transact-SQL) | Microsoft Docs
ms.custom
ms.date	03/14/2017
ms.prod	sql-non-specified
ms.reviewer
ms.suite
ms.technology	database-engine
ms.tgt_pltfrm
ms.topic	language-reference
f1_keywords	sp_cursorunprepare_TSQL sp_cursorunprepare
dev_langs	TSQL
helpviewer_keywords	sp_cursorunprepare
ms.assetid	b46d4813-c4a9-4f9d-9979-2b5082ecf06a
caps.latest.revision	8
author	BYHAM
ms.author	rickbyh
manager	jhubbard

sp_cursorunprepare (Transact-SQL)

[!INCLUDEtsql-appliesto-ss2008-xxxx-xxxx-xxx_md]

Discards the execution plan developed in the sp_cursorprepare stored procedure. sp_cursorunprepare is invoked by specifying ID = 6 in a tabular data stream (TDS) packet.

Applies to: [!INCLUDEssNoVersion] ([!INCLUDEssKatmai] through current version).

Transact-SQL Syntax Conventions

Syntax

  
sp_cursorunprepare handle  

Arguments

handle
Is the handle value that is returned by sp_cursorprepare when the statement is prepared.

See Also

sp_cursorprepare (Transact-SQL)
System Stored Procedures (Transact-SQL)