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
dbcc purgesqlcache prints the following message:
dbcc purgesqlcache
DBCC execution completed. If DBCC printed error messages, contact a user with System Administrator (SA) role.
