question

sql_hunter avatar image
sql_hunter asked

How can I find select transactions in logs?

I want to see who runs select query into my database. I know reading T-logs and it is sure that T-logs don't save any SELECT transactions unless it is Audit. Is there any other trace file of any sys.views that holds this SELECT transactions by default?

transaction-logtrace-files
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
Magnus Ahlkvist avatar image
Magnus Ahlkvist answered

No. Unless you create an audit or a server side trace (audit is much, much more preferable) you can't see who selected what afterwards.

10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.