RPC event and Sql Profiler

• David O

  Hall of Fame

  Points: 3228

  More actions

  January 17, 2008 at 2:40 pm

  #121782

  I'm doing a lot of tracing and trying to get a better understanding of the order event classes fire in. I'm trying to create a simple example script that will generate rpc start, sp start, sp:stmt complete,sp complete and rpc complete. The sp statements are easy but generating rpc has been a pain.

  I have tried executing a stored procedure from dts, query analyzer, sql agent,osql, isql,vbscript using ADO and DMO but none of them are generating the RPC event. I've double checked my trace to make sure I'm tracing that event.

  What kind of connection or app will causes the RPC Start event to fire?

  David

• SQL_EXPAT

  SSCrazy

  Points: 2708

  More actions

  February 4, 2008 at 4:34 am

  #774688

  Hi David

  As a test you can generate RPC events like this:

  OSQL -E

  1> {call sp_who()}

  2> GO

  Hope this helps

  thanks

  SQL_EXPAT