How to get server event notification

Posted on

Question :

I’m just getting into sql-server, so forgive me if this is a basic question. I’m building an application using .NET 4.0 and VS 2010 and ms-server2008.

For my application I need to detect the server response, suppose: in db-server I need to detect which table insert/update/delete records, and which is the affected record is?

Is there any mechanism or technique to detect the server response.

If have any questions please ask.

Answer :

Your options are

  • to use stored procedures for data access and write log of changes,
  • or to use triggers on specified tables to write log of changes

and after it you have periodically poll the log tables to reflect to the tables changes

See related answers:

Leave a Reply

Your email address will not be published. Required fields are marked *