Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Auditing Expand / Collapse
Author
Message
Posted Tuesday, April 27, 2010 6:36 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Friday, February 7, 2014 1:57 AM
Points: 201, Visits: 532
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
Posted Wednesday, April 28, 2010 1:04 AM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Yesterday @ 2:07 AM
Points: 4,100, Visits: 5,456
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
Posted Wednesday, April 28, 2010 1:44 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Friday, February 7, 2014 1:57 AM
Points: 201, Visits: 532
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
Posted Wednesday, April 28, 2010 2:00 AM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Yesterday @ 2:07 AM
Points: 4,100, Visits: 5,456
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
Posted Thursday, April 29, 2010 6:35 AM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Today @ 12:12 AM
Points: 935, Visits: 2,674
never mind

Shawn Melton
PS C:\>(Find-Me).TwitterURL
@wsmelton
PS C:\>(Find-Me).BlogURL
meltondba.wordpress.com
Post #912755
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse