Results 1 to 5 of 5
  1. #1
    Join Date
    Jul 2004
    Posts
    32

    Unanswered: Creating an application event handler for a Stored Procedure

    Is it possible to create an event handler in a VB.net application to run whenever a Stored Procedure is run.

    My application has a scheduled task which is created and scheduled by users of the application, whenever this scheduled task is run I would like it to contact the application to kick off a sequence of tasks. I would appreciate if anybody could point me in the right direction.
    Last edited by gaj; 10-06-04 at 14:23.

  2. #2
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    You can script a custom trace that captures the execution of this task that can instantiate a COM object which in turn can do whatever you want it to do.
    "The data in a record depends on the Key to the record, the Whole Key, and
    nothing but the Key, so help me Codd."

  3. #3
    Join Date
    Jul 2004
    Posts
    32
    I'm new to developement is there anywhere I can learn to do this.

  4. #4
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    I don't know of any way to call code in a VB app running on another machine, but you can create a simple COM object and then use sp_OACreate and the related procedures to launch your COM object on the server.

    Will this do what you want?

    -PatP

  5. #5
    Join Date
    Jul 2004
    Posts
    32
    There both running on the same machine so with a bit of luck I'll be able to get it working.

    Thanks

Posting Permissions

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