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?

  • sqldba_newbie (12/28/2012)


    I don't want to trace to run 24 X7 as i don't know when the issue would occur.

    thats why i asked you to use trace when you are blank in any particular case use it but with PROPER AND REQUIRED filter. as we know that it s a resource intensive operation(that is what you would be thinking here and reluctant to use it ) , but when we have proper filer plus only fetching event which are relevant and required then you can minimize the resoure usage.

    -------Bhuvnesh----------
    I work only to learn Sql Server...though my company pays me for getting their stuff done;-)