How can I clear SQL Server's procedure cache? - 14 Nov 1999

A. With SQL 6.5 and below the only way is to re-start SQL Server.

With SQL 7.0 there is an undocumented and unsupported command - DBCC FREEPROCCACHE.