title: How to maintain Truncate logs in SQL Server
body: <p>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. </p>
  
  <p>I created an Audit but it's for a single database. I don't know how to create an Audit for all databases.</p>