exec sp_rename 'usp_test','uspp_test'
select text from sys.syscomments
where id=object_id('uspp_test')
The text column is still showing as “create procedure usp_test”.
It breaks to run “sp_refreshsqlmodule”
Invalid object name ‘dbo.uspp_test’.
To be able to resolve it, run again “alter procedure ” statement.
Simon's SQL 