Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Track Long Running Queries Expand / Collapse
Author
Message
Posted Sunday, October 14, 2007 2:52 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Monday, July 23, 2012 6:29 AM
Points: 359, Visits: 109
Comments posted to this topic are about the item Track Long Running Queries


Post #410589
Posted Tuesday, December 20, 2011 8:15 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Monday, December 15, 2014 11:47 AM
Points: 321, Visits: 1,293
Does it work with SQL 2008R2? or u have updated script?

Aim to inspire rather than to teach.
SQL Server DBA
Post #1224456
Posted Tuesday, December 20, 2011 8:37 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Monday, December 15, 2014 11:47 AM
Points: 321, Visits: 1,293
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).


Aim to inspire rather than to teach.
SQL Server DBA
Post #1224478
Posted Tuesday, December 20, 2011 8:45 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Monday, December 15, 2014 11:47 AM
Points: 321, Visits: 1,293
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.


Aim to inspire rather than to teach.
SQL Server DBA
Post #1224494
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse