July 16, 2008 at 1:40 pm
How can i tell if someone is running a trace on a sql server 2000? I don't see it in the task manager
July 16, 2008 at 2:13 pm
From Inside SQL Server 2000 you can use select * from :: fn_trace_getinfo(default) which returns information on all active traces.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
July 16, 2008 at 2:14 pm
Try: Select * From ::fn_trace_getinfo(default);
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
July 16, 2008 at 2:17 pm
Run the following command from a query window:
[font="Courier New"]SELECT * FROM ::fn_trace_getinfo(0)[/font]
This will return details for all traces running on your system. Search in Books Online for fn_trace_getinfo for more information.
MARCUS. Why dost thou laugh? It fits not with this hour.
TITUS. Why, I have not another tear to shed;
--Titus Andronicus, William Shakespeare
July 16, 2008 at 2:19 pm
This works. Thanks
July 16, 2008 at 2:25 pm
Jeffrey Williams (7/16/2008)
Try: Select * From ::fn_trace_getinfo(default);
Scott Duncan (7/16/2008)
Run the following command from a query window:[font="Courier New"]SELECT * FROM ::fn_trace_getinfo(0)[/font]
This will return details for all traces running on your system. Search in Books Online for fn_trace_getinfo for more information.
Heh heh, I finally was first on one of these.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
July 16, 2008 at 2:27 pm
I do realize that Thank You.
July 16, 2008 at 8:20 pm
Just to make sure the horse is dead...
You should also be able to see the trace start / stop in the SQL Server Log.
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply