We need to apply some naming standards to existing databases and are trying to rename all the objects. Stored procedures are the problem, I can rename the object using sp_rename but this does not change the name within the procedure i.e. after CREATE PROCEDURE. Does anyone know of a quick way to do this please?