Purging the Statement Cache

Run dbcc purgesqlcache to remove all the SQL statements from the statement cache. Any statements that are currently running are not removed.

You must have the sa_role to run dbcc purgesqlcache.