Sql Server Query Notification and window application: notify only the insert action RRS feed

  • Question

  • Hello..

    I' m not sure whether this question must be adressed to the vb.Net forum ..

    I want to 'do something' in my application when something change on a table ..

    Everything works fine and the SqlDependency OnChange event is raised everytime something change on the table.

    The problem is that if I have 2 insert, 1 update, 1 delete on one batch the Onchange is called once...

    I have to notify my application only when an insert occurs and In case I have 2 insert in the same bathc I have to display that there were 2 inserts ...

    Till now I was not able to find any resource to help me...
    Somebody got the same problem?

    Thank you for any help!

    Marina B.

    Tuesday, April 17, 2007 10:19 AM