Results 1 to 5 of 5
  1. #1
    Join Date
    Nov 2003
    Posts
    3

    Angry Unanswered: Help Stored Procedures

    Stored procedures called from asp pages or from a VB-batch program are not executed completely. There are no error-messages or warnings generated. The SP just stops executing and returns to the initial program as if it was executed normally...

    No idea how this can be solved as those SP seem only to have problems when there's a 'lot' of data that has to be processed. When it's about few data the SP executes normally...

    Any one who can help?

    Thanks!

  2. #2
    Join Date
    Jul 2002
    Location
    Village, MD
    Posts
    621
    Get return code from sp - it was post here about it before - try to find.

  3. #3
    Join Date
    Nov 2003
    Posts
    3

    Re: Help Stored Procedures

    Can't get these return codes as this problem is only happening on production servers, not on dev-servers...

    Supose this must be something to do with settings or so... but no idea which ones...

    Thanks for help!

  4. #4
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322

    Re: Help Stored Procedures

    Originally posted by carlbraems
    The SP just stops executing and returns to the initial program as if it was executed normally...
    Thanks!
    It's that damn miracle thing again...

    Can you repeat the problem?

    Fire up profiler and see what's going on...

    I bet bug in sproc...
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  5. #5
    Join Date
    Nov 2003
    Posts
    3

    Lightbulb

    Found solution:
    These are queries that don't return a recordset and need to have the following setting switched off: SET NOCOUNT.

    Thanks anyway!

Posting Permissions

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