如何侦听SQL Server数据库更改 [英] How do I listen for SQL Server database changes

问题描述

使用.Net 4.0和SQL Server 2008 R2

Using .Net 4.0 and SQL Server 2008 R2

我一直在研究利用SqlDependency/SqlNotifications监视某些数据库结构.为此的最佳过程/最佳实践是将SqlDependency/SqlNotifications与SQL Server Service Broker一起使用吗?

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.

编辑(可能的选项):

1. SqlDependency
2. Service Broker外部激活

推荐答案

查看事件通知:

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

这篇关于如何侦听SQL Server数据库更改的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！