Link to home
Start Free TrialLog in
Avatar of sam2929
sam2929

asked on

store procedure

Hi,
I have a store procedure with many variables from other tables . Is it possible to run that store procedure and see in some kind of sql server monitor to see the sql running with all the variables.

i know in db2 if you execute procedure you can see what sql is running that procedure  is this possible in sql server too.

Thanks,
Avatar of Daniel Reynolds
Daniel Reynolds
Flag of United States of America image

Depending upon your set up, you should be able to debug the Stored Procedure using SSMS.

If you want to see what queries are hitting your db you will want to use SQL Profiler to capture your query and see what the actual values are.

SQL Profiler comes with your SQL Server install. It is a handy tool to do traces of what is happening with your databases.

SSMS of course also comes with SQL Server, check out the ability to do debugging with this via help.
ASKER CERTIFIED SOLUTION
Avatar of Manju
Manju
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial