Thursday, February 4, 2016

Trace Will not Capture row data if got inserted via Bulk Insert

fyi,
i was capturing all events happening against a Table, I was able to find S/I/U/D etc events for few Phone number
But there was a phone number i was particular about and i couldn't see in Insert ,so with the time it got inserted I see SSIS package doing BULK INSERT.


so, what i learned is if we insert data via ssis or bulk copy/insert we will not see ROW data.
we can see  all Statements happening with SSIS or BULK ...



No comments:

Post a Comment

https://blog.sqlauthority.com/2009/06/27/sql-server-fix-error-17892-logon-failed-for-login-due-to-trigger-execution-changed-database-context...