Identify the Changes in Columns Data

You may use the system procedures to get the table changes. CDC provides a set of procedure through which you can get the info.

Ref:

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

http://msdn.microsoft.com/en-us/library/bb500244(v=sql.105).aspx

---

Please use Marked as Answer if my post solved your problem and use Vote As Helpful if a post was useful.