1.

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

Answer»

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.
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/2514397For 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


Discussion

No Comment Found

Related InterviewSolutions