BUG: Application Error When Expanding a Stored Procedure

MORE INFORMATION

   select name,uid from sysobjects
   where uid NOT IN (select uid from sysusers)
      and type = 'P'
				

Steps to Remove the Orphaned Stored Procedure

1. Use either ISQL/W or the SQL Enterprise Manager SQL Query Tool to connect to a database as the database owner (DBO) or system administrator (SA).
2. Execute the SQL query above to find the orphaned stored procedure.
3. Execute the following statements:
   

         use USER_DB       -- user_db is the database with the orphaned object
         go
   
         sp_configure allow,1     -- allows update to system tables
         reconfigure with override
         go
   
         update sysobjects set uid=1
         where name = 'name of stored procedure returned in Step 2'
         go
   
         drop procedure <name of stored procedure returned in Step 2>
         go
   
         sp_configure allow,0     -- disallows update to system tables
         reconfigure with override
         go