Folks, I've inherited a SQL 2K server that has a trace running. I can see the trace file being generated(.trc), I can also see the standard templates(.tdf). But BOL is not helpful in finding information about the
trace when you have no information. I just want to shut the damn thing off.
I can open the trc file in SQL Profiler but I am not proficient in the tool's use. I also don't see a trace table anywere in the database.
If anyone can be of any help it would be much appreciated. Thanks.
I dug around some in SQL Books on Line, but I did not find a whole lot. Look at sp_trace_create. Most of what SQL BOL covers is about the GUI to Profiler, but sp_trace_create is what I am guessing that you are dealing with.
I THOUGHT that you could stop the trace simply by cycling the server. However, I think there is also a property to SQL Agent that allows you to specify a command to execute when SQL Agent start. Unfortunately, I can't remember where the SQL Agent startup option is stored. Still checking...
Thanks guys...I've looked at the stored procs for this but it would appear I would have to supply the traceid which is unknown. My reading continues as I am digging through ny copy of "Inside SQL Server" to see if it can shed some more light. If I solve this one I will be sure to let ya know.
One thing I've learned is that there is server side tracing whcih does not use SQL Profiler, that is used by the client-side component.