Question

I was wondering how to monitor a database for changes programmatically. Suppose I want to have a .net application which would run after every 100th or(nth) row insertion or row deletion or updation . how can it be achieved?
I know little about triggers.they can be used to fire executable.
But I heard that it isn t a good practice. Is there any other way?
2]Do database fire events on table updations? and can they be caught in a program?
3]Can SQL reporting services be used here?

(Also assuming that this application is independent from the actual program which does database manipulation.)

Answer 1

SQL Server 2005 introduced query notifications, new functionality that allows an application to request a notification from SQL Server when the results of a query change. Query notifications allow programmers to design applications that query the database only when there is a change to information that the application has previously retrieved.

Check out the MSDN link for more clarity and sample immplementation

Answer 2

除非你对“100”或“nth”的准确性表示担忧,否则触发因素实际上将是唯一的。

对2和3的答复是没有的。

您可以撰写经过管理的存储程序(MSDN example , 但这确实有助于你。一般来说,触发因素可能是不良的做法,因为它们可能阻碍最初的打电话者,但有时是唯一的解决办法。

Answer 3

我认为,你需要质疑把这一低级数据监测单独应用的要求。考虑您的数据变化可以产生在何处,

各位是否充分了解:

stored proc within your db (now and future) and which ones update this table?
application that may hit your database (now and future)

否则,在数据一级(如在db范围内)跟踪变化可能是最佳选择,可能意味着触发......。

Answer 4

http://msdn.microsoft.com/en-us/library/ms166104(v=SQL.90).aspx”rel=“nofollow” http://msdn.microsoft.com/en-us/library/ms166104(v=SQL.90)。

友情链接