SQL Server 2000: Corrupt Stored Procedure (or syscomments table)

[vukasinganjic]

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.

[DaveLembke]

Have you tried google yet for info on this error?

Lots of hits, and this one might have a solution?

https://communities.vmware.com/message/2514397

[aidenburke]

For more answers and solution take a look at https://social.technet.microsoft.com/Forums/en-US/cc4cfcf8-93ad-4d8e-98db-9f241543da89/my-database-mdf-file-got-corrupted?forum=ssdsgetstarted