Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
sp_unprepare (Transact-SQL)
Collapse the table of content
Expand the table of content

sp_unprepare (Transact-SQL)

SQL Server 2008

Discards the execution plan created by the sp_prepare stored procedure. sp_unprepare is invoked by specifying ID = 15 in a tabular data stream (TDS) packet.

sp_unprepare handle 


Is the handle value returned by sp_prepare.

Other Resources

System Stored Procedures (Transact-SQL)

Community Additions

© 2015 Microsoft