Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

When I am running SQL profiler to trace the sql queries being executed, the trace is showing only Audit logs, not the sql commands being executed. Can somebody tell me how to get the sql commands also? Thanks

share|improve this question

migrated from stackoverflow.com Jan 6 '12 at 15:32

This question came from our site for professional and enthusiast programmers.

add comment

1 Answer 1

In the "Events Selection" tab of the trace definition, make sure that the TextData column is checked for RPC:Completed events.

(This is unchecked in the default trace definition)

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.