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 ...