May 28, 2018 at 5:07 am
Hi,
I've been searching the internet without success.
I am looking for a simple way to see if a user has viewed any records in a table and when this happened.
I believe its possible through transaction Logs but it very confusing, surely there is a simpler way or query that will return this?
Or any kind of help to point me in the right direction.
kind regards
Gerry
May 29, 2018 at 10:28 am
Tallboy - Monday, May 28, 2018 5:07 AMHi,I've been searching the internet without success.
I am looking for a simple way to see if a user has viewed any records in a table and when this happened.
I believe its possible through transaction Logs but it very confusing, surely there is a simpler way or query that will return this?
Or any kind of help to point me in the right direction.
kind regardsGerry
Select statements aren't logged. You would need to use a trace or audit to capture a users select statements.
Sue
May 30, 2018 at 9:44 am
Thanks Sue,
How do I do this myself?
May 30, 2018 at 10:33 am
Tallboy - Wednesday, May 30, 2018 9:44 AMThanks Sue,How do I do this myself?
It depends on what edition of SQL Server 2008 you are on. If you are on enterprise, look at setting up SQL Server Audit. If you aren't on enterprise, you would need to use a server side trace. Another option is a third party tool. The following link has a brief example of all three - including promoting it's own product but it does go over the options:
Auditing SELECT statements on SQL Server
Don't bother with extended events on SQL Server 2008. There are some examples out there using that but extended events are pretty weak on 2008.
Sue
June 13, 2018 at 11:45 pm
This was removed by the editor as SPAM
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply