I basically would like to know from which table or view, a software is loading data from when opening, e.g.: when I push save button, which table does the software uses to update data or load when an action is triggered.

I've tried some ways, like seeing the transaction log file, or the active connections in the database. Also I expected a query like:

SELECT table_name
FROM active_transations_due_to_software

I'm using SQL Server Express License.

CodePudding user response：

Download SSMS and use the SQL Server Profiler.