microsoft.public.sqlserver.notificationsvcs
[Top] [All Lists]

Re: Receiving notifications from SQL Server 2000 that data changed?

Subject: Re: Receiving notifications from SQL Server 2000 that data changed?
From: Joe Webb
Date: Fri, 06 Oct 2006 09:32:53 -0500
Newsgroups: microsoft.public.sqlserver.notificationsvcs
Something like this, perhaps? 

http://www.c-sharpcorner.com/UploadFile/mosessaur/sqlcachedependency01292006135138PM/sqlcachedependency.aspx?ArticleID=3caa7d32-dce0-44dc-8769-77f8448e76bc


-- 
Joe Webb
SQL Server MVP
http://www.sqlns.com


~~~
Get up to speed quickly with SQLNS
http://www.amazon.com/exec/obidos/tg/detail/-/0972688811 

I support PASS, the Professional Association for SQL Server.
(www.sqlpass.org)



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.

<Prev in Thread] Current Thread [Next in Thread>