May 5, 2009 at 5:08 am
Dear All,
I have a stored proceure which takes some parameters and is called by another SP.Means values for those parameters are passed at run time by the SP which is calling it.
I want to view the values passed to the second SP..How can I see it..?
Thanks.
May 5, 2009 at 7:31 am
One method is to use profiler
Failing to plan is Planning to fail
May 5, 2009 at 7:46 am
Is this something you need to do regularly or a one time thing? Profiler or a server-side trace is one option. Another would be to create a table to hold the parameters and insert the values each time the procedure is called with a run_date column as well.
You may also be able to get something from the DMV's that are available in 2005/2008.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
May 5, 2009 at 11:31 pm
It doesn't come in profiler when executed from APPLICATION (Col Fusion). That's the problem.
What about SQL debugger in VS-2005/2008..?
Thanks..
May 6, 2009 at 5:59 am
As coding standards, we always have a @Debug bit parameter to all the stored procedures that defaults to 0. For App debugging, we can pass this as 1 from client which will then be passed to all sprocs. You can have a condition based on this parameter inside required sprocs to log it as Jack pointed out.
May 6, 2009 at 6:16 am
I believe you should see it in Profiler if you have selected the correct events. What events are you collecting?
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply