Home Forums SQL Server 2005 Administering sprocs executed but rolled back? is there any log? RE: sprocs executed but rolled back? is there any log?

  • December 28, 2012 at 10:55 am

    #1572170

    Bhuvnesh (12/28/2012)

    For future, you can set trace and capture that SP.

    I don't want to trace to run 24 X7 as i don't know when the issue would occur. I wanted to know if someone killed a sproc, if i come in later is there a way to find which sproc was killed?