Instead of changing the system catalogs, the procedure should generate a call to the SP_Rename proc to do the same thing in a standard way.