Posted on: 4/19/2013 10:51:47 AM | Views : 313

I am new to SQL Server querying, and am trying to understand Change Tracking for specific tables in the database, but can't seem to get an understanding of it.  All of the tutorials that I am running across are using complex variables that are outside of where I am trying to go with the issue. I am basically trying to find out the best way to find out what changes have been made to a specific table inside of SQL Server 2008 Express.  I know that 'Change Data Capturing' is not available in the Express version of SQL, so I am working with the 'Change Tracking' feature, but can't really seem to understand how to create a function dealing with changes in a table, and I am having a hard time figuring out what variables are utilized when using change tracking. (and what/how they are used for).

I currently have Change Tracking enabled on the database, and also enabled on the specific table I need to track.  I can see basic informatin about the cha ...

Go to the complete details ...