Be Careful while renaming stored procedures, views, functions and triggers.

I suppose, many of us have renamed stored procedures, views, functions and triggers several times in the past. Sometimes renaming such objects can give you some trouble. For example, after you rename an object, sp_helptext or OBJECT_DEFINITION will still give you the object definition with the previous name. This can cause problems some times, especially if you use sp_helptext to retrieve the object definition and make modifications to the procedure/function/trigger/view body.

I have posted my findings about this here: http://blog.sqlserver.me/2008/09/be-careful-when-renaming.html