October 28, 2002 at 9:11 am
SQL Server 2000 Profiler:
SP:StmtCompleted
SP:StmtStarting
SQL:StmtCompleted
SQL:StmtStarting
Are these collecting the same data?
October 28, 2002 at 9:42 am
Maybe. If all your db calls are via a stored procedure than yes, they will collect the same data. If you are sending any plain SQL to the db, then that would only show up in the last two events.
Diane
October 28, 2002 at 9:45 am
ya all my calls are Stored Procedures.
October 28, 2002 at 9:58 am
I believe these are like the Batch Start and Stmt Start for a single line batch. You would essentially get the same information, though different events fire.
I'd only pick one for troubleshooting.
Steve Jones
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply