Sybase Question:
Download Questions PDF

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

Answer:

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.

Download Sybase Interview Questions And Answers PDF

Previous QuestionNext Question
What will cause the size of a stored procedure to grow in Sybase?When are stored procedures compiled in Sybase?