I am executing a SQL using DBC.SYSEXECSQL in a Store Procedure .
Can any one suggest me way to capture the activity count of sql executed
This thread will help you.
I want to use ACTIVITY_COUNT with DBC.SysExecSQL to get how many rows updated by query executed in DBC.SysExecSQL.
The link you suggest, is for DML statements only in any Stored procedure.
Deiter has already answerd your question.