Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
coolerbob
Aged Yak Warrior
841 Posts |
 Posted - 2005-11-21 : 04:27:23
|
| Sorry for this basic question:Scenario:I make a trace (with lots of filters)I run itI go home and shut down my machinenext day I come in, and i want to run the same trace againwhat do I have to save it as the day before in order to do this????Save it as a trace template and I can open it up again the next day and see it there with all my filters but there is no "RUN!" button.I cant find a "Make trace from trace template" functionality either.Opening a trace obviously just lets you rerun the recorded data...How can i accomplish this?I dont want to have to re-create the same freekin trace with all those filters every day!!argh! |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2005-11-21 : 06:03:47
|
| Create new trace, use the following template (select template name), run.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
coolerbob
Aged Yak Warrior
841 Posts |
Posted - 2005-11-21 : 06:54:39
|
| i knew i was being thickthanks |
|
|
|
|
|
|
SQL 2000 Profiler - what am i missing