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

Last Reviewed: April 7, 1999