Track Long Running Queries

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Ferguson » Track Long Running Queries

Track Long Running Queries

Rate Topic

Display Mode

Topic Options

Author

Message

Ferguson

Posted Sunday, October 14, 2007 2:52 AM

Old 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

logicinside22

Posted Tuesday, December 20, 2011 8:15 AM

SSC Veteran

Group: General Forum Members
Last Login: Today @ 10:59 AM
Points: 280, Visits: 1,029

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

Aim to inspire rather than to teach.
SQL Server DBA

Post #1224456

logicinside22

Posted Tuesday, December 20, 2011 8:37 AM

SSC Veteran

Group: General Forum Members
Last Login: Today @ 10:59 AM
Points: 280, Visits: 1,029

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

logicinside22

Posted Tuesday, December 20, 2011 8:45 AM

SSC Veteran

Group: General Forum Members
Last Login: Today @ 10:59 AM
Points: 280, Visits: 1,029

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 »

Permissions