**Tracing**

[M]

Hi
I use SQL Server 2000 and I try to trace and keep its result
activities(by SQL Profiler and by T-SQL),
now there's some question with me:
how can I automatically start a trace everyday?
I made a script on my trace information by SQl profiler
but there was no topic related to the name of table kept
my trace result,why?
how can trace result be stored in different tables related to different
days? in other word how can automatically
change the name of table ,to keep the result of several days?

--
Using M2, Opera's revolutionary e-mail client: [url]http://www.opera.com/m2/[/url]

[Jacco Schalkwijk]

You can't save programmatically created traces to a table directly. They
have to be saved to trace files, which you can ofcourse give a separate name
for each day if you create a separate trace for each day.

You can access the data in the trace file as a table with the function
fn_trace_gettable.

--
Jacco Schalkwijk MCDBA, MCSD, MCSE
Database Administrator
Eurostop Ltd.


"M" <mary2001@canada.com> wrote in message
news:oprrxqjo0ohu9goh@msnews.microsoft.com...

> Hi
> I use SQL Server 2000 and I try to trace and keep its result
> activities(by SQL Profiler and by T-SQL),
> now there's some question with me:
> how can I automatically start a trace everyday?
> I made a script on my trace information by SQl profiler
> but there was no topic related to the name of table kept
> my trace result,why?
> how can trace result be stored in different tables related to different
> days? in other word how can automatically
> change the name of table ,to keep the result of several days?
>
> --
> Using M2, Opera's revolutionary e-mail client: [url]http://www.opera.com/m2/[/url]