Post reply

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

  • April 13, 2009 at 12:25 am

    #130014

    Hi All

    I am getting the following error -

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

    The Sp is called from trigger.

    Can anyone help me to solve the error

    Thanks

    Priyank

  • April 13, 2009 at 7:08 am

    #976546

    Can you please provide more details, especially the code (at least code that approximates it) that is generating the error?

    Without knowing what you are trying to do there is no way to answer your question.

    Jack Corbett
    Consultant - Straight Path Solutions
    Check out these links on how to get faster and more accurate answers:
    Forum Etiquette: How to post data/code on a forum to get the best help
    Need an Answer? Actually, No ... You Need a Question

  • April 13, 2009 at 7:23 am

    #976576

    Check the SQL error log, there may be more details there.

    just as a precaution, please run the following for the DB in question (during a quiet time)

    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 3 (of 3 total)

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