Tag Info

New answers tagged


1) Below is a great script from Paul's blog Script: open transactions with text and planswhich should get you going: SELECT [s_tst].[session_id], [s_es].[login_name] AS [Login Name], DB_NAME (s_tdt.database_id) AS [Database], [s_tdt].[database_transaction_begin_time] AS [Begin Time], [s_tdt].[database_transaction_log_bytes_used] AS [Log ...


This means you set AUDIT .. BY SESSION instead of AUDIT .. BY ACCESS. When you use BY SESSION, the ACTION_NAME contains SESSION REC, and the actual actions performed by that session are stored in the SES_ACTIONS column as characters. For example the value ---------S------ means there was a select on the object, as each character represents the following ...

Top 50 recent answers are included