Secrets of SQL Server Series
How to Capture Who did what in Your SQL Server Database
Ever needed to figure out who made a change or when a change was made? Are you required to log certain activities for compliance purposes?
SQL Server supplies a variety of tools to help you accomplish that. This presentation will show you how to use those tools, including:
• Default Trace
• Built-in Auditing
• Transaction Log
• DDL Triggers
We’ll also examine at least one use case for each tool to help you better understand what your options are in every situation.