Something like this, perhaps?
SQL Server MVP
Get up to speed quickly with SQLNS
I support PASS, the Professional Association for SQL Server.
On Wed, 27 Sep 2006 15:19:01 -0700, MobileMan
<[email protected]> wrote:
>What is the best way to be notified, from SQL Server 2000, that a row was
>added, deleted, or modified in another application?
>I'm a competent C# developer, but a "babe in the woods" when it comes to SQL
>Server. I have been reading about the Notification "engine" in SQL Server
>2005 and am looking for something similar for a SQL Server 2000 setup.
>We have an application that uses SQL Server 2000 for data storage. When a
>new record is created or deleted, or an existing record modified we want to
>somehow "notify" another application of this fact.
>In a perfect world we would sent an "event" from SQL Server 2000 to the 2005
>server, or even better to another application that is listening for events
>from the 2000 server. If our "listening application" can receive the event
>then we can handle things from there.
>Any suggestions or thoughts are greatly appreciated. Thanks for your advice.