Help on Profiler

Hello:
I have setup a sqltrace to trace another sql server and
write to local sql table. I have try to defind the
template but it can't save the trace server and write to
local sql table. Is it possible to execute the sql trace
by simple way?
Thanks!
It's never a good idea to trace and have it write directly to a table. You
should always have it write to a file on a locally attached drive. You can
then easily import the file into a table later. This way you will have the
least amount of impact on the server while tracing. See the following and
the associated sp's in BooksOnLine.
sp_trace_create
fn_trace_gettable
Andrew J. Kelly SQL MVP
"Alan" <anonymous@.discussions.microsoft.com> wrote in message
news:2ef801c4a22e$3624e740$a601280a@.phx.gbl...
> Hello:
> I have setup a sqltrace to trace another sql server and
> write to local sql table. I have try to defind the
> template but it can't save the trace server and write to
> local sql table. Is it possible to execute the sql trace
> by simple way?
> Thanks!
sql