As a database changes, you can optimize original query plans used to access its tables by recompiling them with sp_recompile. This saves you from having to find, drop, and re-create every stored procedure and trigger. This example marks every stored procedure and trigger that accesses the table titles to be recompiled the next time it is executed.
sp_recompile titles
For detailed information about sp_recompile, see the Reference Manual.
