Results 1 to 2 of 2

Thread: Corrupt Stored procs on SQL Server 6.5

  1. #1
    Mike Cooling Guest

    Corrupt Stored procs on SQL Server 6.5


    Hi

    Recently I have experienced the following scary scenario;

    Users report a problem with an app, on diagnosis it is found that a bunch of SPs in SQL Server seem to be corrupt.

    That is, when the code for them is listed, the 'Create Procedure..' line and several DECLARE lines are missing. Often the SP starts off in the middle of a variable name!!

    Perhaps entries in the syscomments table have become corrupted?

    Has anyone seen this problem before - is it perhaps a known bug in SQL Server 6.5?

    Regards,

  2. #2
    Craig Guest

    Corrupt Stored procs on SQL Server 6.5 (reply)

    What are the results of dbcc checkdb, newalloc, and checkcatalog against the database in question?


    ------------
    Mike Cooling at 6/20/00 8:06:08 PM


    Hi

    Recently I have experienced the following scary scenario;

    Users report a problem with an app, on diagnosis it is found that a bunch of SPs in SQL Server seem to be corrupt.

    That is, when the code for them is listed, the 'Create Procedure..' line and several DECLARE lines are missing. Often the SP starts off in the middle of a variable name!!

    Perhaps entries in the syscomments table have become corrupted?

    Has anyone seen this problem before - is it perhaps a known bug in SQL Server 6.5?

    Regards,

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •