How to track database change history

All replies

• 

  

  0

  Sign in to vote

  What type of change?  Schema changes?  Use a proper source control mechanism.

  Wednesday, February 24, 2016 4:27 PM
• 

  

  0

  Sign in to vote

  Hello - Few options that can be used, such as:

  1. Default Trace File Data (Schema change history report)
  2. Create SQL Server Audit (Recommended)
  3. Your own custom server side trace (Not usually recommended)
  4. Database scoped triggers (Not usually recommended)
  5. Change Tracking/ Change Data Capture (Depends on your requirement)

  ---

  Good Luck!
  Please Mark This As Answer if it solved your issue.
  Please Vote This As Helpful if it helps to solve your issue

  • Proposed as answer by Eric__Zhang Thursday, February 25, 2016 5:50 AM
  • Marked as answer by himalkumar Tuesday, March 1, 2016 8:03 PM

  Wednesday, February 24, 2016 4:33 PM