Under SQL Server 2000, I'm having a problem using (or viewing) a stored procedure. When trying to view the SP using the Enterprise Manager I'm getting this error message:
Error 0:[SQL-DMO]Object 'dbo.SP_ProcName' was not scripted. It is possible that the information in system table 'syscomments' about the object was corrupt or missing?
I can delete the SP using this interface without issue (by right-clicking on it and selecting 'Delete'). I can, using the Query Analyzer, recreate it using a CREATE PROCEDURE script. When I try to use or view this script after recreating it, however, I get the same error message.