OnUpdate-type event notification for SQL Server tables?

From: Joel Thornton (joelpt_at_gmail.com)
Date: 11/23/04 

Date: 23 Nov 2004 11:47:47 -0800

I'm looking for advice on the best way to monitor a specific SQL
Server 2000 table for changes from an external application. I'll be
writing this app in either C#/.NET or VB/ASP.

Obviously I can monitor the table for changes by polling once per
interval (1 second here). I was hoping SQL Server has some kind of
event notification system I can hook up to so that I can avoid the
polling.

Any thoughts are appreciated!

Joel Thornton

Relevant Pages

  • Re: How to monitor Triggers in VB6
    ... You can use Profiler to or SQL Trace to monitor what's currently executing ... Vyas, MVP (SQL Server) ... > I have this triggers in T-SQL to execute when a product qty is 0, ...
    (microsoft.public.sqlserver.programming)
  • SQL Performance Object Counters not seen
    ... Performance Log group, with admin privileges on the SQL ... Server to monitor over Terminal Services. ...
    (microsoft.public.sqlserver.security)
  • Re: Best choice of technology
    ... I would consider creating a DTS task in SQL ... You can partially monitor it, so it may not be choice #1. ... Server 2005, ...
    (microsoft.public.dotnet.general)
  • Re: Lisp backend protocol
    ... The problem with this is that you then have a Lisp out there ... A process reads SQL queries, ... There is no need for polling: ... functions written in Lisp acts as the SQL server. ...
    (comp.lang.lisp)
  • Re: Lisp backend protocol
    ... The problem with this is that you then have a Lisp out there ... A process reads SQL queries, ... There is no need for polling: ... functions written in Lisp acts as the SQL server. ...
    (comp.lang.lisp)