Post reply

stored procedure

  • July 3, 2013 at 7:59 am

    #276930

    Hi,

    I am working in a xyz comapny. I have a live database where everyday huge records are inserting. but from past few days one of the stored procedure is not executing. I checked query and the BI application also where I called stored procedure . I am not able to find what is the problem.

    Please help me regarding this issue asap.

    Thanks,

    Arooj

  • July 3, 2013 at 9:36 am

    #1629593

    Run a trace, and look for the calls of the proc.

    Get the data, run them manually, look for an error or other issue.

    There's no quick/easy way to give you that solves this. There could be lots of problems. However if it just stopped working, something changed. Someone changed code, added a trigger, out of space, something.

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

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