Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

SqlDependency and Notification Services

1 view
Skip to first unread message

GrzybSon

unread,
Oct 18, 2010, 2:49:22 PM10/18/10
to
Hello,

Currently I'm creating some notification layer for MS SQL 2k5 and i'm
using SqlDependency class for this. It is working fine but i need some
additional info about change in data in db, for example i want to have a
list of last inserted/updated/deleted row id's for every monitored
table. Can this be achived with SqlDependency? I know that it can be
done by creating trigger for every monitored table but this could be
very painfull when it comes to monitor 100+ tables.

--
Regards,
Macko

0 new messages