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

  • In SSMS, expand SQL Server Agent, right-click Alerts and select New Alert. When setting up the alert you can specify how you want to be notified.