How do I listen for SQL Server database changes

Question

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):

SqlDependency
Service Broker External Activation

FYI - SQL Notification services was deprecated, so I wouldn't try to go down that path. This sounds somewhat related (not exactly) to: stackoverflow.com/questions/877273/… — ChrisLively
– ChrisLively, Commented Feb 15, 2012 at 19:10
What kind of structures? Data? Schema? Also, why do you want to do this / what problem are you trying to solve? — RQDQ
– RQDQ, Commented Feb 15, 2012 at 19:10
@RQDQ we have a high volume application where we have to perform quite a few DB lookups. I wanted to try and eliminate some of this overhead by caching or leveraging something else to store the static data...until changed — scarpacci
– scarpacci, Commented Feb 15, 2012 at 19:15
@ChrisLively thanks.....I will take a look at the stack question — scarpacci
– scarpacci, Commented Feb 15, 2012 at 19:15

Jimbo · Accepted Answer · 2012-02-15 19:12:21Z

4

Check out event notifications:

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

answered Feb 15, 2012 at 19:12

Jimbo

2,53719 silver badges22 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How do I listen for SQL Server database changes

1 Answer 1

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Linked

Related