(AI KB) PCS KB: How to Enable Change Tracking

This is a guide meant to explain how to enable Change Tracking in PCS. This feature allows users to see changes made to data within PCS once the feature is Enabled. 

Please Note: This feature is not retroactive: all changes tracked are after the feature has been enabled and the changes for the last year are as far back as the PCS UI can show. 

Your IT/DBA Admin needs to enable the VIEW_SERVER_STATE permission at the SQL Server level for every PCS user. Typically this permission is granted to an Active Directory group to avoid applying it to individual users. As an aside, this permission is required so the end users can pull transaction information (date/time, etc.)  from SQL's transaction log.

After this is complete, make sure whoever is going to check the Change Tracking box within PCS has the db_owner permission and go to Tools > Options to see if it is available to be checked. If it's available, check the box and you're done-- a button for change tracking will appear in the data grids and reports.

If the box is still grayed out, the person who is going to enable change tracking will need SysAdmin permissions. The easiest path would be for your DBA to grant an end user that permission temporarily until the box can be checked, and then it can be revoked. If your DBA would like to push the button themselves, they can use your PCS key and release it once done. 

For Further Assistance Please Submit a Technical Support Ticket