Simon's SQL

SQL,DBA,tuning,Trouble Shooting,Performance

Archive for August 5th, 2013

sp_rename will not change sys.syscomments table definition.

Posted by Simon Cho on 08/05/2013

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.

Posted in Common | Leave a Comment »