|
Posted by birju on 06/02/06 12:54
Hi,
I'm running SQL Profiler on an SQL Server 2000 database. I see that one
stored procedure gets repeatedly executed having a handle of '1'. This
query takes a long time to complete.
How do I find what the text of the stored procedure is? I cant see any
handle being created (using sp_prepare) with an id of '1' in the
profiler. Is there any way to force the server to re-prepare all
statements so that I can see the statement text and its preparation in
SQL Profiler?
Cheers,
Birju
Navigation:
[Reply to this message]
|