INF: Conditions When Stored Procedures Are Recompiled by SQL
ID: Q62860
|
The information in this article applies to:
-
Microsoft SQL Server versions 4.2x, 6.0, 6.5
-
Microsoft SQL Server for OS/2, version 4.2
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.
SUMMARY
MORE INFORMATION
Additional query words:
Keywords : kbprg SSrvStProc SSrvServer
Version : OS/2:4.2; winnt:4.2x,6.0,6.5
Platform : OS/2 winnt
Issue type : kbinfo
|