CODEWITHSUNDEEP
sqlsql-serverdatabase
bajivali shaik
bajivali shaik

Reputation: 81

How to retrieve the history of changes happened to a particular Id in a table in SQL Server

I have a table 

select * 
from fServiceDetail  
where id = 111

For Id = 111 in table fServiceDetail I want to see all past changes that happened across all columns till now as a list.

How can I do that? Please help.

Upvotes: 1

Views: 48

Answers (1)

Hadi
Hadi

Reputation: 37348

You cannot achieve this if you do not have a historical or archive table that store this data.

OR

You have to use a third-party log reader (if log is not shrinked) like ApexSQL LOG

Upvotes: 1

Related Questions