Reports the text of a particular stored procedure (including triggers, a special kind of stored procedure) being executed for a particular process. If both CUR_STMT_ACT_STP_DB_ID is equal to 0 and CUR_STMT_ACT_STP_ID is equal to 0 then a stored procedure is not currently executing and this text is a null-terminated empty string ("").
If the text is not available (because this stored procedure was compiled and its text was discarded, or because the text is stored in an encrypted format), then this text is a null-terminated empty string ("").
11.5 and later
Result
No
SMC_NAME_SPID
None
VALUE_ SAMPLE |
VALUE_ SESSION |
RATE_ SAMPLE |
RATE_ SESSION |
AVG_ SAMPLE |
AVG_ SESSION |
|---|---|---|---|---|---|
CHARP |
