On my test server, a large request is executed (which is good), but this is a multi-line request. For instance. in SSMS, I told him to run something like:
begin transaction;
query;
query;
query;
query;
commit;
I want to see what query is running on the list. Selecting textfrom sys.dm_exec_sql_textreturns the entire statement, not the specific command executed in the list. Is there a way to view the individual commands that are being processed?
In case it matters (sometimes it happens), it runs on an instance of SQL Azure.
source
share