Take a look in the trace for what commands were being run by the same SPID (if that's in the trace). That should tell you what proc or script is being run. If you have the text field in the trace (assuming that you do and that's where you got the exec command), it might even contain the create command for the temp proc. That's where I'd start.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon