Re: OnUpdate-type event notification for SQL Server tables?

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: Tom Cole (tusnuy_at_hotmail.com)
Date: 11/23/04 

Date: Tue, 23 Nov 2004 12:40:06 -0800

Assuming that you are talking about data changes.

Here's a thought.

You can try using Triggers in conjunction with xp_cmdshell.

Be careful with the security setting, an intruder can really hose your
system if they gain access to xp_cmdshell.

"Joel Thornton" <joelpt@gmail.com> wrote in message
news:a6e041a1.0411231147.2a4bbc51@posting.google.com...
> 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: OnUpdate-type event notification for SQL Server tables?
    ... and write a program that polls your custom table. ... > I'm looking for advice on the best way to monitor a specific SQL ... > Obviously I can monitor the table for changes by polling once per ... I was hoping SQL Server has some kind of ...
    (microsoft.public.sqlserver.programming)
  • Re: Batch Requests/Sec counter
    ... The performance monitor shows it at the scale of 1000 so ... >I support the Professional Association for SQL Server ... >> The batch requests per second shown on the performance ... network card is only ...
    (microsoft.public.sqlserver.server)
  • Re: Monitor Transaction log
    ... On the client end you can poll to queue ... >>> Is there a way to monitor transaction log in SQL server and Oracle ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Batch Requests/Sec counter
    ... The scale on performance monitor only affects the position of the graph. ... I support the Professional Association for SQL Server ... >>> The batch requests per second shown on the performance ...
    (microsoft.public.sqlserver.server)
  • Re: SSIS Packages fail, but takes a LONG time to end
    ... How to monitor blocking in SQL Server 2005 and in SQL Server 2000http://support.microsoft.com/default.aspx/kb/271509 ... Some failures roll back quickly and fail the package; ...
    (microsoft.public.sqlserver.server)