none
trigger not running on insert RRS feed

  • Question

  • Using NS2005 and this application is working. I am interested in turning off vacuumer. How to do that?

    But in the meantime I was testing a trigger in my Events table. Filewatcher is working and posting events to this table, but my Insert trigger is not running. It will run if I directly enter a new record into the table so I know it's working.

    Is SSNS doing something unique in writing to the events table? And is this why my Events table trigger does not run?

    Monday, April 24, 2006 7:06 PM

Answers

  • Hi DevDells -

    >I am interested in turning off vacuumer. How to do that?

    Change the setting in the ADF and run NSControl update (or update via SSMS). But are you sure you want to do that? It's a good idea to let the vacuumer run periodically to clean up obsolete data. Otherwise your system will continue to grow.

    As for your other question, can you elaborate? I'm not sure I completely understand the question.

    Thanks!

    Joe

     

     

     

    Friday, May 5, 2006 8:45 PM
    Moderator