• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 444
  • 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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Microsoft Windows 7 Basic

This introductory course to Windows 7 environment will teach you about working with the Windows operating system. You will learn about basic functions including start menu; the desktop; managing files, folders, and libraries.

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