Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Is there a way in SQL profiler to filter by INSERT statements?

Tags:

People also ask

Is SQL Server Profiler deprecated?

SQL Server Profiler is an interface to create and manage traces and analyze and replay trace results. Events are saved in a trace file that can later be analyzed or used to replay a specific series of steps when diagnosing a problem. SQL Trace and SQL Server Profiler are deprecated.


I am trying to identify SQL INSERTS that occur when a record is viewed from a Windows application. In SQL Profiler I have a long list of stored procedures that fire when the record is viewed, however it is very cumbersome to identify the stored procedure then locate the inserts, then find the stored procedure in the object explorer (even with filters).

Is there a way for me to see all SQL commands on a line item instead of a stored procedure? And then filter by INSERT statements?

Thanks for any assitance!