Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Other SQL Server Topics (2005)
 SSNS - Getting events upon DB changes (Not schedu

Author  Topic 

eladgovari
Starting Member

3 Posts

Posted - 2007-02-01 : 10:25:30
Hi.
i'm trying to set an Event Provider that will provide me with events when a specific data changes in a specific table in the DB.
I've noticed that the built-in SQL Provider polls the DB using a schedule and that doesn't help me.
I'm thinking of implementing a customed event provider but I'm looking for a way to get events upon DB changes without using an interval (a continues event provider).
is there any way to do it OTHER THAN using a QueryNotification ?
if the best way is indeed using QueryNotification - is there a way of using it with the notification services ? and if anyone had done it - any documentation / code examples / links would be highly appreciated !

Thanks !
   

- Advertisement -