SAP ASE upgrades compiled objects based on their source text.
Check constraints
Defaults
Rules
Stored procedures (including extended stored procedures)
Triggers
Views
The source text of each compiled object is stored in the syscomments table, unless it has been manually deleted. When you upgrade the server, the existence of the source text in syscomments is verified during that process. However, the compiled objects are not actually upgraded until they are invoked.
For example, if you have a user-defined stored procedure named list_proc, the presence of source text for list_proc is verified when you upgrade to the latest version of SAP ASE. The first time list_proc is invoked after the upgrade, SAP ASE detects that the list_proc compiled object has not been upgraded. SAP ASE recompiles list_proc, based on the source text in syscomments. The newly compiled object is then executed.
Upgraded objects retain the same object ID and permissions that they used before being upgraded.
Compiled objects for which the source text was hidden using sp_hidetext are upgraded in the same manner as objects for which the source text is not hidden. See the Reference Manual: Procedures.
To ensure that compiled objects have been successfully upgraded before they are invoked, you can upgrade them manually using the dbcc upgrade_object command.