ID Number: Q62860
1.10 1.11 4.20
OS/2
Summary:
The following list contains the various conditions under which SQL
Server will recompile a stored procedure:
- An index is dropped on the referenced table.
- The table is dropped and re-created.
- A rule or default is added to the table.
- The procedure is dropped and re-created.
- All copies of the execution plan in the cache are currently in use.
- The procedure executed was created using the WITH RECOMPILE option.
- The procedure was executed with the WITH RECOMPILE option.
- The requested procedure is no longer in the cache.
Additional reference words: 1.10 1.11 4.20