Monitoring truncates, bulk inserts and bcp operations

• walty81

  SSC Rookie

  Points: 35

  More actions

  June 27, 2012 at 3:01 pm

  #271767

  Hi all, I would like to know when truncate, bulk insert and bcp operations are performed. Can anyone suggest an approach or feature that would allow me to track such operations?

  I am basically just interested in knowing when these operations have occurred and the target table.

  Thanks in advance for any suggestions you can provide.

• spaghettidba

  SSC Guru

  Points: 105732

  More actions

  June 27, 2012 at 4:09 pm

  #1506394

  A SQL Server Audit could do the trick.

  I haven't checked, but I'm pretty sure you can capture those events.

  Hope this helps

  Gianluca

  -- Gianluca Sartori