Nakul Vachhrajani (10/6/2010)
This is bound to happen.Per BOL (http://msdn.microsoft.com/en-us/library/ms188351.aspx):
Changing any part of an object name can break scripts and stored procedures. We recommend you do not use this statement to rename stored procedures, triggers, user-defined functions, or views; instead, drop the object and re-create it with the new name.
Please always drop & recreate stored procedures.
Also, please avoid using syscomments - this will be deprecated in a future version of SQL Server. Use sys.sql_modules instead.
Thanks & Regards,
Nakul Vachhrajani.
http://nakulvachhrajani.com
Follow me on
Twitter: @sqltwins