Execute SP and return control to ASP page

Ask a Question related to ASP Database, Design and Development.

  1. #1

    Default Execute SP and return control to ASP page

    I have a SQL Server 2000 stored procedure that I execute from an ASP page.
    This stored procedure in return fires a trigger that sometimes takes awhile
    to finish processing (for various, known and reasonable reasons).

    I'm wondering how to call this stored procedure in ASP and then return
    control to the ASP page without having to wait for the StoredProcedure to
    finish?



    JasonH Guest

  2. Similar Questions and Discussions

    1. Execute VB program within a CF page
      To start, we are still using CF 5. The user submits a file via a form that then goes to the submit page. On the submit page after some basic...
    2. execute PHP -> return output to string
      Hi I've got a problem and I hope someone can help me: I want a PHP script to call another PHP script, execute it and return its OUTPUT (not...
    3. User control code behind does not execute
      Anybody have any ideas as to why my user control code will not execute the server side code? I converted an .aspx page to an .ascx user control. ...
    4. server.execute return value??
      i hope no one is getting sick of my server.execute/transfer questions.. does server.execute return a value? im wondering what happens if an error...
    5. Prevent 'Page has expired' when a client hits back to return to a search page
      I have a search page that I want to enable private caching so that when a user hits the back button they dont get the page has expired error. I...
  3. #2

    Default Re: Execute SP and return control to ASP page

    Here's a decent link.
    [url]http://www.aspfaq.com/2194[/url]

    Ray at work

    "JasonH" <jeh@netvoiceinc.com> wrote in message
    news:%23fQOqHmmDHA.2512@TK2MSFTNGP09.phx.gbl...
    > I have a SQL Server 2000 stored procedure that I execute from an ASP page.
    > This stored procedure in return fires a trigger that sometimes takes
    awhile
    > to finish processing (for various, known and reasonable reasons).
    >
    > I'm wondering how to call this stored procedure in ASP and then return
    > control to the ASP page without having to wait for the StoredProcedure to
    > finish?
    >
    >
    >

    Ray at Guest

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139