SQL Server Profiler Does Not Display SQL Statements Built into ColdFusion Components

Question

In our ColdFusion 11 application with SQL Server 2008 R2. The .cfm file uses the CF component, which is called with syntax, for example:

<cfscript> objMyTable = createobject('component','components.myTable); qmyTable2list = objMyTable.loadAllCustomers(); qresultset = objMyTable.loadCustomersResultset(form.applicant_type, form.customer_name, form.state, form.orderby); </cfscript> 

The CF component has SQL statements such as the following:

 <cfquery name="result_set" dataSource="#request.dsn_name#"> select name, state from myTable #REReplace(where_clause,"''","'","ALL")# </cfquery> 

When we click the button on the .cfm page, the application correctly displays data from SQL Server 2008 R2. But SQL Profiler does not catch these SQL statements. When we run the profiler on .cfm pages that use the built-in cfquery tags for sql queries (instead of CF components), the SQL profiler displays all the queries made by this page. Question How to force SQL Profiler to catch queries inside CF component?

UPDATE I have the following events selected in the profiler:

Answer 1

Grab the "RPC: Completed" and / or "RPC: Starting" events and you will see your ColdFusion requests.