If you rename any of the objects it 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 Adaptive Server 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.
