Sql Profiler Scan Started to execute a stored procedure
by Lieven Cardoen
on Stack Overflow
See other posts from Stack Overflow
or by Lieven Cardoen
Published on 2010-03-14T14:56:08Z Indexed on 2010/03/14 15:25 UTC
Read the original article Hit count: 277
Does SqlServer has to start a Scan to execute a stored procedure?
In Sql Profiler I can see this:
- RPC Starting ( exec sp_Edu3_SelectExamSession @ExamSessionId=N'AccessCode39361814' )
- RPC Completed ( exec sp_Edu3_SelectExamSession @ExamSessionId=N'AccessCode39361814' )
Can I somehow see what's happening in the Stored Procedure? Different queries are done in that SP, but they do not seem to appear in Sql Profiler (maybe I need to check some more events?)
The Scan:Started are probably scans by the queries in the sp? Or not?
© Stack Overflow or respective owner