Auditing

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server Newbies » Auditing

Auditing

Rate Topic

Display Mode

Topic Options

Author

Message

Djcarpen11

Posted Tuesday, April 27, 2010 6:36 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, May 21, 2013 4:10 AM
Points: 195, Visits: 471

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

Post #911034

Stewart "Arturius" Campbell

Posted Wednesday, April 28, 2010 1:04 AM

Hall of Fame

Group: General Forum Members
Last Login: Thursday, May 23, 2013 8:31 AM
Points: 3,129, Visits: 4,312

consider using Change Data Capture
http://msdn.microsoft.com/en-us/library/bb522489.aspx

____________________________________________
Space, the final frontier? not any more...
All limits henceforth are self-imposed.
“libera tute vulgaris ex”

Post #911659

Djcarpen11

Posted Wednesday, April 28, 2010 1:44 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, May 21, 2013 4:10 AM
Points: 195, Visits: 471

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.

Post #911676

Stewart "Arturius" Campbell

Posted Wednesday, April 28, 2010 2:00 AM

Hall of Fame

Group: General Forum Members
Last Login: Thursday, May 23, 2013 8:31 AM
Points: 3,129, Visits: 4,312

Check out the following:
http://msdn.microsoft.com/en-us/library/cc280386.aspx
http://msdn.microsoft.com/en-us/library/cc280663.aspx

____________________________________________
Space, the final frontier? not any more...
All limits henceforth are self-imposed.
“libera tute vulgaris ex”

Post #911684

Shawn Melton

Posted Thursday, April 29, 2010 6:35 AM

Right there with Babe

Group: General Forum Members
Last Login: Saturday, May 11, 2013 8:56 PM
Points: 754, Visits: 1,891

never mind

--------------------------------------------------------------
Shawn Melton
@wshawnmelton

Post #912755

« Prev Topic | Next Topic »

Permissions