Who changed that record in SQL-Server?
From time to time you may get the question: “who changed that information in SQL-Server?” or even to recover the original information in that record. Lots of software designers create there own solution but how about going back to basic, back to SQL-Server?
Muhammad Imran wrote an excellent article about this on his blog. It is possible to answer all the questions and even recover records with only SQL-Server.
For my personal archive a link to the original article: SQL Server – How to find Who Modified / Updated What records at What Time.