Solved

how to script trace definition from trc file in sql2005

Posted on 2010-09-23
5
416 Views
Last Modified: 2012-08-14
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
Comment
Question by:motioneye
  • 3
5 Comments
 
LVL 8

Expert Comment

by:Narender Gakka
Comment Utility
Did you go to the Properties and checked whether you could modify it and get the desired result out of it.
0
 
LVL 29

Accepted Solution

by:
QPR earned 500 total points
Comment Utility
you script out trace templates as opposed to loaded trace files don't you?
tdf not trc
0
 
LVL 29

Assisted Solution

by:QPR
QPR earned 500 total points
Comment Utility
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
 

Author Comment

by:motioneye
Comment Utility
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
 
LVL 29

Assisted Solution

by:QPR
QPR earned 500 total points
Comment Utility
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

What Security Threats Are You Missing?

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

Suggested Solutions

In this article—a derivative of my DaytaBase.org blog post (http://daytabase.org/2011/06/18/what-week-is-it/)—I will explore a few different perspectives on which week today's date falls within using Microsoft SQL Server. First, to frame this stu…
Nowadays, some of developer are too much worried about data. Who is using data, who is updating it etc. etc. Because, data is more costlier in term of money and information. So security of data is focusing concern in days. Lets' understand the Au…
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.

728 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now