How to maintain Truncate logs in SQL Server

Question

I have a stored procedure which truncate all tables of my database. I want to trace the truncate for each table. So that if it fails somewhere, I could see where it is stopped and which tables are truncated successfully.

I created an Audit but it's for a single database. I don't know how to create an Audit for all databases.

Is there an alternative ? As i have to keep record of which tables are truncated successfully — Abdul, Apr 05 '17 at 07:21

score 0 · Answer 1 · answered Apr 05 '17 at 07:23

0

you can create DDL triggers, Hope it can fulfil your requirement.

answered Apr 05 '17 at 07:23

Sudhakar Singh

71
4

How to maintain Truncate logs in SQL Server

1 Answers1