SQL Log of a truncate action
-
Is there a specific place to see evidence that a truncate action was performed as part of a backup from within SQL?
-
The "truncate" is essentially a transact-sql. Is your SQL db setup to track all historical SQL executions? That table is where I would look first.
-
@nashbrydges said in SQL Log of a truncate action:
The "truncate" is essentially a transact-sql. Is your SQL db setup to track all historical SQL executions? That table is where I would look first.
How would I do such a thing as setting up the tracking?
-
@grey This might help get you started. There are 2 types of change tracking for MS SQL. Pick the one most appropriate for your scenario.
