For SQL Server 2008 R2 :
In the top menu: Tools -> SQL Server Profiler
Select server name:

The Trace Properties dialog box appears.
Go to the Events Selection tab:

Check Show all columns
Slide the horizontal scroll bar to the right.
Check the boxes below the RowCounts column.

Click Run
Tracing starts to appear. The RowCounts column will be on the right. You can drag it to the left if you want.
source share