Post reply

Urgert [server error occured ]

  • July 25, 2009 at 9:25 am

    #137020

    Hi All,

    Im receiving an error while running a sp on a server.

    "A severe error occurred on the current command. The results, if any, should be discarded."

    Untill last week the Sp executed successfully and now we are experiencing this error.

    Can any one suggest how to fix the issue. It is pretty urgent:(

    Regards,

    Sandhya

  • July 25, 2009 at 9:29 am

    #1030156

    HI Experts,

    I would like to add one more point here.

    No information is logged in the sql server error logs at the time of the failure of the SP

    Regards,

    Sandhya

  • July 25, 2009 at 2:00 pm

    #1030205

    Please run this and post the results.

    DBCC CHECKDB (< Database Name > ) WITH NO_INFOMSGS, ALL_ERRORMSGS

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply