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 |
|
jbates99
Constraint Violating Yak Guru
396 Posts |
 Posted - 2011-02-15 : 21:02:28
|
| Hi experts,I ran a (2005) profiler trace today, outputting to a table.I set it to auto stop at 5 pm. Tomorrow if I click the green arrow (Start the selected trace) will it *append* to the existing rows that are in my trace table or will it truncate them? I don't want to lose the existing records but would rather not have to build another trace either.Thanks, John |
|
|
dmaxj
Posting Yak Master
174 Posts |
Posted - 2011-02-15 : 21:54:50
|
| How are you starting your trace? |
 |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2011-02-16 : 14:31:36
|
| it will prompt you for a new table name, or ask if you want to replace the existing table. |
|
|
|
jbates99
Constraint Violating Yak Guru
396 Posts |
Posted - 2011-03-06 : 18:13:21
|
| Thanks, Russell.It's too bad that it doesn't just append to the existing table. I only run the traces during certain hours but I would like to collect several days of trace info into a single table. Oh well....John |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2011-03-06 : 21:34:56
|
| You can query them with UNION ALL. Or pop everything from the various traces into one table. |
|
|
|
|
|
|
Restarting A Profiler Trace