sql server profiler
Posted on 2010-01-09
I'm just investigating a very complex issue in my VB application and this application is calling many stored procedures at various stages. What I wanted to do is as I debug through each calling stroed procedure I wanted to see what is being passed to that procedure and what is being produced by the SP as a result of those passed in values. I thought I might use SQL Server Profiler to help me do that but I never use this tool before so can someone, tell me how do I set this up with my application so I will be able to see what happening in the database as I step through the application source code.