Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  SQL Server Administration (2000)  How to see what a temp stored procedure does?

Author  Topic  MuadDBA 628 Posts Posted - 2004-02-11 : 14:16:15 I am running a profiler to try to track down some intermittent deadlocking issues I have, but one of the apps connects via JDBC and uses temporary stored procedures to execute code on my server. How can I see what these temporary procedures are doing once they are already created? If I begin the trace before they are created, I can see their create statements, but other than that, how do I do it?