question

askmlx121 avatar image
askmlx121 asked

how to see the input parameter of Stored Procedure using sql profiler? can anyone explain step by step process or screenshot?

Hi I want to view the store procedures input/output parameter using sql profiler. Is it possible? can anyone give me step by step explanatory for how to do that? quick answers are highly appreciated........any sql expert can help me...........a lot...
sql-server-2008profiler
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

· Write an Answer
jhowe avatar image
jhowe answered
This is easy. Start up profiler, select template TSQL_SPs. Go to Events Selection tab, untick everything and only tick along row SP:Completed to see what you require. Hope this helps.
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.