After the upgrade was completed, how can all stored procedures be verified before releasing to business users? For example:
dbcc upgrade was run and it reported no errors - but when the execution took place, it failed.
set switch on 3604
dbcc upgrade_object(mydb, myproc)
DBCC upgrade_object: Upgrading PROCEDURE dbo.myproc
DBCC upgrade_object: PROCEDURE dbo.myproc upgraded successfully.
set switch off 3604
Msg 11035, Level 16, State 1:
Server 'myserver', Line 1:
Execution of procedure myproc failed because upgrade found no entry in syscomments for this object. Please drop and recreate dbo.myproc
Database error code: 11031
Database error message:
Execution of procedure myproc failed because of errors parsing the source text in syscomments during upgrade. Please drop and recreate dbo.myproc.
SAP Adaptive Server Enterprise
upgrade, compiled objects, verify, verification, error, execution, syscomments , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , How To
About this pageThis is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).
Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.