Createing a trace to load a table

Hi All,
Is there a programmatic way to create a trace that loads a table?
I created a trace that loads a table; I started it and stopped it. I
scripted the trace to SQL 2000, and tried to start the trace with the SQL
code created by the profiler in query Analyzer. I have been running these
where they load files with no problems.
I added the table name to procedure where it tells me to add a file name but
the table does not load.
Is this possible? Running to file first leaves me open for SOX to say this
is not fully a live audit, there will be up to an hour depending how fast the
files load.
TIA,
Joe
jaylou wrote:
> Hi All,
> Is there a programmatic way to create a trace that loads a table?
> I created a trace that loads a table; I started it and stopped it. I
> scripted the trace to SQL 2000, and tried to start the trace with the
> SQL code created by the profiler in query Analyzer. I have been
> running these where they load files with no problems.
> I added the table name to procedure where it tells me to add a file
> name but the table does not load.
> Is this possible? Running to file first leaves me open for SOX to
> say this is not fully a live audit, there will be up to an hour
> depending how fast the files load.
> TIA,
> Joe
There is no way to trace to a table directly with a guarantee that all
events will be captured. You need to do what you are already doing. That
is, trace to a flat file on the server itself and then migrate that
trace file information to a trace table if needed once the trace
completes. The file loads real time. It's just that you can't query the
file while SQL Server has it open. Once the trace completes or the trace
does a rollover to a second file, you can query the first.
David Gugick
Quest Software
www.imceda.com
www.quest.com
|||thanks again David.
"David Gugick" wrote:

> jaylou wrote:
> There is no way to trace to a table directly with a guarantee that all
> events will be captured. You need to do what you are already doing. That
> is, trace to a flat file on the server itself and then migrate that
> trace file information to a trace table if needed once the trace
> completes. The file loads real time. It's just that you can't query the
> file while SQL Server has it open. Once the trace completes or the trace
> does a rollover to a second file, you can query the first.
> --
> David Gugick
> Quest Software
> www.imceda.com
> www.quest.com
>