What causes re-resolution of a stored procedure

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

What causes re-resolution of a stored procedure in Sybase?

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.

(Continued on next question...)

Other Job Interview Questions

• Explain about the features of Sybase IQ?
• Recovery from Large Identity value gaps in Sybase
• Fixing a Munged Log in Sybase ?
• Are there any alternatives to isql in Sybase ?
• How do I pipe the output of one isql to another?
• Connecting to ASE Using OLTP in Sybase
• Explain about Power Designer Data modeling software?
• How can I return number of rows that are returned from a grouped query without using a temporary table?
• How do I set a password to be null?
• How Do I Choose Which Tables To Partition in Sybase?
• More...