0

I have an application that interacts with SQL Server 2008. I want to write a tool that help me identifying the SQL statements that causes hard delete in the table. Is it possible to find out using the SQL Profiler? or should i write triggers in all the stored procedures to find out that? how to achieve it. any directions would be helpful.

Jeeva
  • 4,585
  • 2
  • 32
  • 56
  • what is exactly hard delete ? Do you have some sort of IsDeleted flag in the table ? – Antonio Bakula Mar 15 '13 at 10:24
  • Yes we have flag that will do soft delete but at times we completely remove the row from the table that is what we need to identify – Jeeva Mar 15 '13 at 10:27

1 Answers1

1

First, take a look to Monitoring the progress of an SQL query in SQL SERVER. To monitor progress for some sql query see example.

Community
  • 1
  • 1
Mihai8
  • 3,113
  • 1
  • 21
  • 31