How do i see "INSERT" Transaction log in Microsoft SQL Server?

Question

I am trying to find out how does my script from another system insert into the database as it takes 30 minutes, way too long. I want to see how every record in which period is being inserted.

The database server has multiple database and each database has multiple tables. If I only want to see INSERT record in a database called PB_IG and table name ecmpb.CHAR_VALUE, what should I do?

use sql server profiler and filter text with "Pg_IG" – Ed Bangga Sep 25 '19 at 02:21 — Ed Bangga, Sep 25 '19 at 02:21

Ed Bangga · Accepted Answer · 2019-09-25T03:01:43.233

2

run your sql server profiler, go to "New Trace" -> "Event Selections" tab, and filter your trace textdata property

edited Sep 25 '19 at 03:01

answered Sep 25 '19 at 02:25

Ed Bangga

12,879
4
16
30

How do you open that? I am at SQL Server profiler and couldnt find that screen. – B.Dick Sep 25 '19 at 02:59
New trace, then Event Selections Tab – Ed Bangga Sep 25 '19 at 03:01

How do i see "INSERT" Transaction log in Microsoft SQL Server?

1 Answers1