Invoke action on SQL Server 2000 Table Change

Question

There any way to let an application know if there is any specific change on a database table (like an insert, update...) without checking the database in a specific interval? The database server is a SQL Server 2000 Enterprise Version

Something like triggers but on the application level.

Thanks,
rAyt

Answer 1

You should be able to do it using SQLDependency classes, I would think. Though they are normally used for caching, you could probably do other stuff. Have a read of Using SqlDependency for data change events .

Answer 2

Step 1 would be to upgrade to a database server that's not about ten years old. Step 2 would be to use the DDL Triggers technology of SQL Server 2008 to solve the problem.