saving a trace to table in SQL Profiler

Hi All,
On Trace Properties General tab of SQL Server 2000, there
is a check box setting for saving a trace to a table. The
trace properties dialog box asks for the name of the
table, thus I am assuming first, I must create the table.
The question is how do i figure out how many columns and
what column names i should have in this table in which i
am going to save the trace.
Thanks,
MitraThere is no need to create the table first. Profiler will create the table
for you. The table that is created has one column for data column you
select in you profiler session, plus it adds and identity column.
----
----
--
Need SQL Server Examples check out my website at
http://www.geocities.com/sqlserverexamples
"Mitra Fatholahi" <mitra928@.hotmail.com> wrote in message
news:12bf701c4433f$6d5f76b0$a401280a@.phx
.gbl...
> Hi All,
> On Trace Properties General tab of SQL Server 2000, there
> is a check box setting for saving a trace to a table. The
> trace properties dialog box asks for the name of the
> table, thus I am assuming first, I must create the table.
> The question is how do i figure out how many columns and
> what column names i should have in this table in which i
> am going to save the trace.
> Thanks,
> Mitra|||Mitra,
And as a For What It Is Worth: If you save the trace into a file and later
want to load a table, the fn_trace_gettable also creates the table for you.
This approach has the advantage of not putting the load of inserting tables
rows on the server and the disadvantage that you cannot query the trace data
until after the file is closed. (But this is usually fine for analyzing
problems.)
Russell Fields
"Mitra Fatholahi" <mitra928@.hotmail.com> wrote in message
news:12bf701c4433f$6d5f76b0$a401280a@.phx
.gbl...
> Hi All,
> On Trace Properties General tab of SQL Server 2000, there
> is a check box setting for saving a trace to a table. The
> trace properties dialog box asks for the name of the
> table, thus I am assuming first, I must create the table.
> The question is how do i figure out how many columns and
> what column names i should have in this table in which i
> am going to save the trace.
> Thanks,
> Mitra