• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 437
  • Last Modified:

how to script trace definition from trc file in sql2005

I have run server side trace, now I need to edit my trace, I tried with old *.trc file open and try to script them, but that option doesn't visible to me. I don't want to build thsi from scratch as it involved very complex setting.


trace-file.jpg
0
motioneye
Asked:
motioneye
  • 3
3 Solutions
 
Narender GakkaAWS / DevOps / Cloud ConsultantCommented:
Did you go to the Properties and checked whether you could modify it and get the desired result out of it.
0
 
QPRCommented:
you script out trace templates as opposed to loaded trace files don't you?
tdf not trc
0
 
QPRCommented:
in other words you start with a blank template, modify all your columns/filters to suit and then script that out to create a sql file that can create this template at a later date when required
0
 
motioneyeAuthor Commented:
Hi,
I don't want to tart with blank template, as I said its complex.. anyway I can extract this from trc files ? or can I extract this from somewhere inside sql since its been running as server side trace?
0
 
QPRCommented:
Not as far as I know. You add columns and filters then save that as a template rather than try to create a template from a previosly created trc file. But as I say, only as far as I know. If there is a trick then I haven't seen ot
0

Featured Post

[Webinar] Cloud and Mobile-First Strategy

Maybe you’ve fully adopted the cloud since the beginning. Or maybe you started with on-prem resources but are pursuing a “cloud and mobile first” strategy. Getting to that end state has its challenges. Discover how to build out a 100% cloud and mobile IT strategy in this webinar.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now