Post reply

Auditing

  • April 27, 2010 at 6:36 am

    #234301

    Hi,

    I've been asked to look at implmenting a auditing process on 2 sql 08 boxes. I've read lots of info about the subject but I'm still a little unsure how best to implement this. I'd ideally like to have the auditing files inserted via a ssis package into a new sqldb on it's own server

    I only have to audit any select,updates,deletes on 10 tables across the two servers and I need to log all the processes done my sysadmin.

    The question I'd like some advice on or pointers in the right direction is

    1. How do I grab the correct file in the ssis package? - for example what happens when the file rolls over? And I'm I best just saving this to file rather than app log or tran log?

    Thanks

    Dave

  • April 28, 2010 at 1:04 am

    This was removed by the editor as SPAM

  • April 28, 2010 at 1:44 am

    #1158685

    Thanks for the reply, That would option would be great, however I've now been told I need to audit all changes made to exsiting and new logins created on the databases, so the Change Data Capture won't work for this.

  • April 28, 2010 at 2:00 am

    This was removed by the editor as SPAM

  • April 29, 2010 at 6:35 am

    #1159603

    never mind

    Shawn Melton
    Twitter: @wsmelton
    Blog: wsmelton.github.com
    Github: wsmelton

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

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