Post reply

Is it possible in SQL 2008 to Audit directly to a table in a database?

  • October 13, 2011 at 1:51 pm

    #250081

    We would like to do native SQL 2008 auditing. Is it possible to do this directly to a database. I know the options are to log to a file or event log, but I am wondering if anyone has done this to a database.

  • October 18, 2011 at 12:04 pm

    #1396246

    The only way I know of to get the Audit information into DB is to import it manually into a DB.

    -Roy

  • October 18, 2011 at 5:11 pm

    #1396395

    Thanks, I thought as much

  • October 19, 2011 at 4:02 am

    #1396522

    You could probably set up a trigger that logs events into a table.

    With SQL auditing, you can query the audit file that it creates and pull that results into a table.

Viewing 4 posts - 1 through 3 (of 3 total)

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