Viewing Transaction Log

  • 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

  • Tallboy - Monday, May 28, 2018 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

    Select statements aren't logged. You would need to use a trace or audit to capture a users select statements.

    Sue

  • Thanks Sue,

    How do I do this myself?

  • Tallboy - Wednesday, May 30, 2018 9:44 AM

    Thanks 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

  • 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