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 ...)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

What are the steps to fix damaged MDF files in SQL Server? 0
Severed connections in SQL Server Connection Pool 1
Catch SQL Server event 2
Access 2010 append query to SQL is very slow 0
Connections in pool not being reused 7
Call stored procedure in SSMS from Access 2016 doesn't work. 0
SQL: Specific LIKE statement 1
Access Print Files from Query Results 0

Back
Top