On sqlserver 2019 server,How do I write sql statement to query all operations on the server with the following fields?

Question

On sqlserver 2019 server,How do I write sql statement to query all operations on the server with the following fields?

Answer 1

Hi @heling song ,

> 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.

Answer 2

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'