Export (0) Print
Expand All

DBCC FREEPROCCACHE

SQL Server 2000

Removes all elements from the procedure cache.

Syntax

DBCC FREEPROCCACHE

Remarks

Use DBCC FREEPROCCACHE to clear the procedure cache. Freeing the procedure cache would cause, for example, an ad-hoc SQL statement to be recompiled rather than reused from the cache.

Result Sets
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
Permissions

DBCC FREEPROCACHE permissions default to members of the sysadmin and serveradmin fixed server role only, and are not transferable.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft