Rename Objects Referenced by Procedures

If you rename any of the objects a stored procedure references, you must drop and re-create the procedure.

Although a stored procedure that references a table or view with a changed name may seem to work fine for a while, it in fact works only until SAP ASE recompiles it. Recompiling occurs for many reasons and without notification to the user.

Use sp_depends to get a report of the objects referenced by a procedure.