SQL Dependency to track DB changes and get record details of the Changed/Inserted Object

Question

0.00/5 (No votes)

See more:

I know there are lot of questions that might be similar to this, But I am confused a bit.

My only question is, I want to track database to know what is changed and get the details of the changed record, And then insert this chaged row into another table. Is this possible with SQL Dependency in .NET?

We are using SQL Server 2012. Your help will be greately appreciated. Thanks

Posted 6-Jan-13 21:44pm

Anurag Sable

Add a Solution

1 solution

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Sandeep Mewara · Answer 1 · 2013-01-06T22:03:00

Solution 1

AFAIK, using TRIGGERS you can create referencing entities and thus use SQL dependency to track the changes.
A quick overview of SQL dependency here: MSDN: Understanding SQL Dependencies[^]

Posted 6-Jan-13 22:03pm

Sandeep Mewara

SQL Dependency to track DB changes and get record details of the Changed/Inserted Object

1 solution

Solution 1

Add your solution here

Preview 0

SQL Dependency to track DB changes and get record details of the Changed/Inserted Object

1 solution

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us