How to catch SQL event in managed code

  • Thread starter Thread starter Edvin
  • Start date Start date
E

Edvin

Hi,
I have application which is writting data to SQL table. I
have also some demon process, which is pooling new
records from that table and if new record is found demon
starts some task. Now I would like to change this pooling
with triggering, of course if this is posible. So, my
question is, is it possible in managed code to be
registered for some event, which is triggerd from SQL
server when for example new record is added to specific
table.

Thanks
Edvin
 
Do not know if there's another way to do it , but you can use 'PRINT' statement in your SQL/Trigger
and the 'InfoMessage' (do not remember exact name) event of the connection object ... (no tested,
but it should works ...)
 
Back
Top