Show Row Count in SQL Profiler

Is it possible to show a “Row Count” column in SQL Server Profiler?

For example there are CPU and Duration columns but can it show how many rows a query returns?

  • Synchronize DataSet
  • DateTime's representation in milliseconds?
  • Can't import as null value SQL Server 2008 TSV file
  • Sum values from one column if Index column is distinct?
  • Update a table from two comma separated parameter as input
  • How Can I Manage SQL Server Log Size
  • 3 Solutions collect form web for “Show Row Count in SQL Profiler”

    How about using the RowCounts column?

    For SQL Server 2008 R2:
    From the top menu: Tools -> SQL Server Profiler
    Choose the Server name:

    enter image description here

    The Trace Properties dialog will appear.
    Click on the Events Selection tab:

    Events Selection

    Click on the Show all columns check box
    Slide the horizontal scroll bar to the right.
    Check the boxes under the column RowCounts

    enter image description here

    Click Run

    The trace will start displaying. The RowCounts column will be to the very right.
    You can drag it to the left if you so desire.

    Quite simply, no. It’s not a measurable in profiler

    MS SQL Server is a Microsoft SQL Database product, include sql server standard, sql server management studio, sql server express and so on.