This tool can help us listen to the database. This article focuses on listening to all operations on the database

Select Sql Server Profiler from the drop – down menu and open it

Step 2 (Login) Picture click me: Enter our login information.

Step 3 (after login interface) Image click me: the title can be arbitrarily selected, we next select our event selection bar

Step 4 (event selection bar) Picture click me: We select all columns, bottom right corner, do not know the location of the view picture:

Step 5 (Select all columns) Picture point ME: After selecting, we need to remove some options and check some options

Step 6 (uncheck Events) Picture click me: Uncheck the first and second items in the Events column

Step 7 (check database) Picture click me: Drag the scroll bar to the middle and check all the options in the DatabaseName column that can be checked

We can also press CTRL + F5 to do some searches for the events we need.

Here is the picture flow

Find our tools

landing

The interface after login

Event selection bar

Select all columns

Click to select all columns

After selecting, we need to remove a few options and check a few options

Uncheck the first and second items in the Events column:

Uncheck the content as shown in the figure below

Drag the scroll bar to the center and check all the checkable options in the DatabaseName column

Finally, click Run to see all the results

We can also press CTRL + F5 to do some searches for the events we need

Welcome to qq group communication: 704028989

Sql Server Profiler