Posted by Erland Sommarskog on 10/15/05 00:28

byrocat (bdealhoy@sympatico.ca) writes:
> So, if we go through the exercise of defining the events that we wish
> to trace and generate the script file and then run the script file,
> this means that the settings are permanent (i.e., rebooting the server
> will not terminate the settings)?

First of all, since you probably want to look at the data, and you
can do that while the trace is running, you would need a job that
stops the trace, moved the file away and then restarts the trace.

You can specify a max size, and a rollover, so that the engine performs
this trick when the file has reached a certain size. But if it takes
a while for the file to fill up, that's not good.

And, no, the trace does not survive a server reboot. Put the script
in a stored procedure, and mark this procedure as a startup procedure.

> Can I also assume that the script can be used to set up can be used on
> other servers without changes?

Yes.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp

[Back to original message]