Monitor table , if any insert happensin that table call the stored procedure using notification service RRS feed

  • Question

  • i have a one source table,in which data is inserted when the feed is over. my job is to monitor that table,if any new record inserted i need to call the stored procedure which has some business logic to it..

    I suggested the asynchronous trigger using service broker to my project manager. but he need that to be done with the sql server notification service.
    i don't know how to map this scenario with notification service. i need a quick solution ya....

    please can any one help as soon as possible.
    Wednesday, November 5, 2008 6:15 PM

All replies

  • can anyone please help with this scenario......
    Wednesday, November 5, 2008 6:32 PM