Track Long Running Queries

• Ferguson

  SSCertifiable

  Points: 5837

  More actions

  October 14, 2007 at 2:52 am

  #182998

  Comments posted to this topic are about the item Track Long Running Queries

• SQlLogic

  SSCrazy Eights

  Points: 9686

  More actions

  December 20, 2011 at 8:15 am

  #1423659

  Does it work with SQL 2008R2? or u have updated script?

• SQlLogic

  SSCrazy Eights

  Points: 9686

  More actions

  December 20, 2011 at 8:37 am

  #1423679

  Gewtting this error when running on sql 2008R2

  Msg 14234, Level 16, State 1, Procedure sp_verify_job, Line 243

  The specified '@notify_email_operator_name' is invalid (valid values are returned by sp_help_operator).

• SQlLogic

  SSCrazy Eights

  Points: 9686

  More actions

  December 20, 2011 at 8:45 am

  #1423694

  Solve Above error by passing NULL

  now this error i got

  Msg 19062, Level 16, State 1, Procedure sp_trace_create, Line 1

  Could not create a trace file.