November 28, 2007 at 1:46 am
Hi Guys/Gals
Is there any way to use a script to startup Profiler,
And instead of writing the results to a file, I need to write directly to
A Table.
Any Input is Valuable.
Thanx
November 28, 2007 at 1:58 am
With sp_trace_create you an create your own trace. The easiest way is prpobably to define a trace in profiler and then script the trace definition.
About writing the results to a table that's not supported in sp_trace_create, but anyway it's no big effort to load the file into a table afterwards just use fn_trace_gettable.
Markus
[font="Verdana"]Markus Bohse[/font]
November 28, 2007 at 2:45 am
Thanx Markus
I have used profiler to write to a table, and it works fine,
i just need to setup jobs to start up the process after the backup and restore. and using the scripts are the best bet, if profiler can
allow me to write to a table im sure there is a way to do this using a script.
Nish
November 28, 2007 at 1:55 pm
Once you have setup profiler to do whatever you want you can script the trace definition from Profiler UI.
Then run those at will with sp_trace_xxx procedures
* Noel
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply