After stopping the trace try using

sp_trace_setstatus traceid, 2

This actually closes the trace.

Thanks Grant - BenchMark Factory was something I came across previously - unless someone has something else to offer this is the one I'll recommend.

Thanks Grant!

Your solution is great. Thanks for sharing!

Thanks for the reply Grant,

I guess I need some clarification. I am using a stored procedure insert to insert records into a table - the primary key is not...

That's 7000 records added daily - over time I would prefer not to query hundreds of thousands of records to get the distinct list.

Thanks all! These posts provided answers to all my questions!

Thanks for the posts! The admin access is for installation only. My plan right now is to grant the access and let them do the install while I...