Deleting statements from the statement cache

Use dbcc purgesqlcache to remove statements from the statement cache. When you specify the statement ID, only the corresponding statement is deleted from the cache.

The syntax for dbcc purgesqlcache is:

dbcc purgesqlcache (int SSQLID)