Error 2835

Severity

16

Message text

The procedure tree is old.  Use the sp_remap procedure to remap all the procedures in this database.

Explanation

When you execute a stored procedure, Adaptive Server checks to determine whether the procedure is already in cache. If the procedure is not in cache, Adaptive Server reads the procedure into the sysprocedures cache and recompiles it. Before Adaptive Server recompiles the procedure, it checks the Adaptive Server release number of the procedure to make sure it is up-to-date for the current release.

Error 2835 occurs when:

Action

Use sp_remap to remap each procedure, trigger, rule, default, and view in the current database:

1> use <database_name>
2> go
1> sp_remap <object_name>
2> go

Where <database_name> is the name of the database where the object resides and <object_name> is the name of the object to remap.

If you have many objects to remap, perform the procedure in “Remapping all database objects” in the most recent version of the Troubleshooting and Disaster Recovery guide.

Additional information

Refer to the Reference Manual: Procedures for information about using sp_remap.

Versions in which this error is raised

All versions