Error When Renaming Stored Procedures
When I ran a compairison I got the following:
PRINT N'Creating [dbo].b]g4_Document_Sort_Parts[/b'
CREATE PROCEDURE dbo.sp_SetDocumentPartSort
I made some cosmetic changes to g4_Document_Sort_Parts (added a comment) and it started working.
Looks like the is a bug when the only change is a change to the name of the object.