Home Forums SQL Server 2008 SQL Server 2008 Administration How to identify which transaction is generating "Longest Transaction Running Time" alert RE: How to identify which transaction is generating "Longest Transaction Running Time" alert

  • September 12, 2011 at 11:39 am

    #1380238

    You'll have to use a job to send you the e-mail which will be 100% customizable.

    In the alert ask to start a job, then use my query to generate usefull output, then sp_send_dbmail