dbTalk Databases Forums  

Trace Sp.

microsoft.public.sqlserver.clients microsoft.public.sqlserver.clients


Discuss Trace Sp. in the microsoft.public.sqlserver.clients forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Noor
 
Posts: n/a

Default Trace Sp. - 06-04-2009 , 08:47 PM






Dear Professional,

I would like to schedule the trace stored procedure to start at 5 AM and end
at 6 AM and also would like to specify the specific filtration for instance
Database Name = 'ABC' and Duration > 1000. How I can achieve this. I can
schedule though SQL Agent but which stored procedure I can schedule?

Please advice.

Thanks



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.