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 |
|
scottpt
Posting Yak Master
186 Posts |
 Posted - 2002-08-06 : 15:50:04
|
| I am running the same trace on multiple servers. I want to be able to take the trace file and import it into a table and then crunch the data. I would like to to this automatically do this without any user intervention. Any ideas? |
|
|
efelito
Constraint Violating Yak Guru
478 Posts |
Posted - 2002-08-06 : 16:57:57
|
| Why not just save the trace data to tables in the first place? Then you could combine them easily if you wanted to or leave them in seperate tables and create a view that covers all of them.Jeff BanschbachConsultant, MCDBA |
 |
|
|
scottpt
Posting Yak Master
186 Posts |
Posted - 2002-08-07 : 10:39:27
|
| I have created a startup proc to kick off the trace using sp_trace_create. It does not support putting the data into a table. |
|
|
|
Page47
Master Smack Fu Yak Hacker
2878 Posts |
Posted - 2002-08-07 : 10:52:03
|
| Are you on sql 2k or sql 7 . . .In SQL 2k, you use the ::fn_trace_gettable function to read the file into the table.In SQL 7, you use the xp_trace_setqueuedestination proc to specify the trace destination (and it can be a table)....Jay White{0} |
|
|
|
scottpt
Posting Yak Master
186 Posts |
Posted - 2002-08-07 : 11:49:19
|
| I am using 2k. This worked like a champ. Thanks for all your help. |
|
|
|
Page47
Master Smack Fu Yak Hacker
2878 Posts |
Posted - 2002-08-07 : 12:42:50
|
| Yeah, that's one thing I never understood why they changed from 7 to 2K.I used to have a server-side trace (meaning a trace running without profiler, set up with the trace procs) running on a 7 box that monitored for failed logins. It would write the event to a table and I had a trigger on the table to send me an email.In 2K, I had to modify it to write to a file and then I had to create a scheduled job that ran every minute to read in the file to the table. Much uglier, IMHO.Anybody have any insite as to why they changed this?Jay White{0} |
|
|
|
|
|
|
Import .trc into a table