Trace all the transactions applied to a table

  • I am looking for a way to capture all the transactions applied to a single table in a database for audit purposes. I do not want to use triggers if at all possible. Can I get this level of granularity using Profiler trace?

  • quote:


    I am looking for a way to capture all the transactions applied to a single table in a database for audit purposes. I do not want to use triggers if at all possible. Can I get this level of granularity using Profiler trace?


    Crosspost?!?

    Cheers,

    Frank

    --
    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply