| Author |
Start a trace from T-sql
|
|
| Stijn Verrept 2005-10-28, 7:23 am |
| I've already searched google groups for this and found
xp_trace_addnewqueue
to do it. However that procedure doesn't seem to
exist in my master database. How is this possible? I checked on
multiple servers?
How can I start a trace to a trace file and have endtime included?
Thanks in advance,
Stijn Verrept.
| |
| Narayana Vyas Kondreddi 2005-10-28, 7:23 am |
| The procedure you are referring to is for SQL Server 7.0 I think.
There is a different set of procedures in SQL Server 2000. You can find them
here:
http://vyaskn.tripod.com/ server_si..._sql_server.htm
You can also find my wrapper stored procedures at the above link.
--
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @ http://vyaskn.tripod.com/
"Stijn Verrept" <stjin@entrysoft.com> wrote in message
news:grOdnTZBusgLfPz
eRVnyhQ@scarlet.biz...
I've already searched google groups for this and found
xp_trace_addnewqueue
to do it. However that procedure doesn't seem to
exist in my master database. How is this possible? I checked on
multiple servers?
How can I start a trace to a trace file and have endtime included?
Thanks in advance,
Stijn Verrept.
| |
| Stijn Verrept 2005-10-28, 7:23 am |
| Narayana Vyas Kondreddi wrote:
> The procedure you are referring to is for SQL Server 7.0 I think.
>
> There is a different set of procedures in SQL Server 2000. You can
> find them here:
>
> http://vyaskn.tripod.com/ server_si..._sql_server.htm
>
> You can also find my wrapper stored procedures at the above link.
Perfect! Thanks a lot!
| |
| Patrick 2005-10-28, 8:23 pm |
| Hi,
One other useful way to script a trace is setup a Profiler trace (with
endtime), run and pause the trace then choose File, Script trace from the
Profiler menu.
Voila - you have a script that can be run (after a few changes). You should
modify @maxfilesize and second and third parameters (rollover? and file
location/name).
Patrick
"Stijn Verrept" wrote:
> I've already searched google groups for this and found
> xp_trace_addnewqueue
to do it. However that procedure doesn't seem to
> exist in my master database. How is this possible? I checked on
> multiple servers?
>
> How can I start a trace to a trace file and have endtime included?
>
>
> Thanks in advance,
>
> Stijn Verrept.
>
|
|
|
|