When a stored procedure references an object that is modified after the creation of the stored procedure, the stored procedure must be re-resolved. Re-resolution is the process of verifying the location of referenced objects, including the object id number. Re-resolution will occur under the following circumstances:

1. One of the tables used by the stored procedure is dropped and re-created.

2. A rule or default is bound to one of the tables (or unbound).

3. The user runs sp_recompile on one of the tables.

4. The database the stored procedure belongs to is re-loaded.

5. The database that one of the stored procedure's tables is located in is re-loaded.

6. The database that one of the stored procedure's tables is located in is dropped and re-created.