Thanks for the response - I appreciate your feedback. 

To go a little deeper:

The user temp database is set in simple mode, there is a stored procedure...

got it. looks like my window has passed because I can only see *.trc files from the past 24 hours. 

appreciate all the help!

hmm... default traces are the same on both setups (prd vs. uat) when i use following

SELECT * FROM :: fn_trace_getinfo(default)

If the trace settings are...