Hi, Kay_Lee
Thanks for posting in forum!
For read only permission, the method that you can choose is too less(such as pull the data and compare it to the data you have before, this is not a good solution), suggest you to get help from someone who have more permission in order to built a solution
- there are multiple option to track changing in table data.
Please reading below blog, this blog cover the available options to implement change tracking over a Microsoft SQL Server database. It also discuss the pros and cons of each method.
This blog talked about :
•“Crawling” tables
•Working with triggers
•Change Tracking
•Change Data Capture
•Query Notification
SQL Server: Overview of different methods for change tracking
Thank you.
MSDN Community Support Elin
Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other
community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.