CODEWITHSUNDEEP
c#sql-serversql-server-2008-r2
scarpacci
scarpacci

Reputation: 9194

How do I listen for SQL Server database changes

Using .Net 4.0 and SQL Server 2008 R2

I have been looking into utilizing SqlDependency / SqlNotifications for monitoring some database structures. Is the best process / practice for this to utilize the SqlDependency / SqlNotifications with SQL Server Service broker?

Are folks using other methods to accomplish a similar task? I could always poll for changes, but I would rather not have to do that. On the other hand I don't want to introduce a complex scenario into our existing environment either.

EDIT (Potential Options):

  1. SqlDependency
  2. Service Broker External Activation

Upvotes: 9

Views: 9079

Answers (1)

Jimbo
Jimbo

Reputation: 2537

Check out event notifications:

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

Upvotes: 4

Related Questions