Trace stored proc calling event

Hot Topic

MOVING SSIS PACKAGES FROM ONE PATH TO ANOTHER ONE
Problem retrieving data from a linked server to Oracle
Link Server to MySQL Database
splitting table from dataset in layout
problems at beginning of set up
Troubleshoot Distributed Service Broker App
Stored Procedure Not returning rows in Web Application
SQL2000 Enterprise Manager error: An error 1051 - (A stop.....
fn_virtualfilestats doesn't work
SMO & DMO FAQ

SQL Server

Express to Standard upgrade
Best way to read a paradox file?
Catching more then one Error
Restarting SQL Server Agent on live env.
Sqlbulk Copy operation fails after copying a specified number of rows everytime.
Install problem
[FOR DISCUSSION] What could be a better solution
Adding Data Viewer causes BI Studio to crash
Exclude duplicate records
SQL EXPRESS - WEB ASSISTANT Sp's

Trace stored proc calling event

I wanna use the SQL Profiler to trace some stored proc. calling events, such callings are originated from an .NET or Java application. Which event, RPC:Starting or SP:Starting, should I use

Answer this question

Trace stored proc calling event

  • Asim A

    Hi,

    look in the MSDN Online Library. It describes the events in detail. RPC means RemoteProcedureCall, SP mean Stored procedure. These event are for showing the information which is sgiving when any of these events occur.

    HTH, Jens Suessmeyer.

    ---
    http://www.sqlserver2005.de
    ---

  • Mike Batton

    Start with:

    STMT:Starting
    SP:Starting
    Errors
    eventually audits

    HTH, jens Suessmeyer.

    ---
    http://www.sqlserver2005.de
    ---

  • Neels215375

    Thanks for your reply, Jens. But what's the difference between RPC:Starting and SP:Starting When I run a trace which montoring these two events, sometimes their contents are the same. Anybody knows the exact definitions of these two events
  • Trace stored proc calling event
Answer this question