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,
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,
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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.