On sqlserver 2019 server,How do I write sql statement to query all operations on the server with the following fields?
On sqlserver 2019 server,How do I write sql statement to query all operations on the server with the following fields?
Hi @helingsong-5963,
We have not received a response from you. Did the reply(s) could help you? If the response helped, do "Accept Answer". If it is not, please let us know. By doing so, it will benefit all community members who are having this similar issue. Your contribution is highly appreciated.
Hi @helingsong-5963,
How do I write sql statement to query all operations on the server with the following fields?
SQL server statement query could not meet your requirement. But you can using ApexSQL Log( a well known third party tool) to achieve this goal. Below is using ApexSQL tool read the SQL server transaction log in my environment.

You can download this tool from this link.
Below screenshot is also a Example for this tool.

If the response is helpful, please click "Accept Answer" and upvote it, as this could help other community members looking for similar queries.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
If you mean all currently running operation, they can be queried with
select pro.cmd, pro.*
from sys.sysprocesses as pro
where pro.status = 'runnable'
9 people are following this question.
Year and Month aggregation in same Pivot table in SQL Server
SQL Server Query for Searching by word in a string with word breakers
How to show first row group by part id and compliance type based on priorities of Document type?
Query to list all the databases that have a specific user
T-sql query to find the biggest table in a database with a clustered index