Geek Answers Handbook

How to listen for SQL Server database changes

Using .Net 4.0 and SQL Server 2008 R2

I studied using SqlDependency / SqlNotifications to monitor some database structures. Is the best process / practice for this to use SqlDependency / SqlNotifications with a SQL Server service broker?

Do people help other methods accomplish a similar task? I could always vote for changes, but I would prefer not to. On the other hand, I do not want to introduce a complex script into our existing environment.

EDIT (Possible Options):

  • SqlDependency
  • External activation of a service broker
+5
source share
1 answer

Check event notifications:

http://msdn.microsoft.com/en-us/library/ms175854.aspx

+2

More articles:


All Articles