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 in sql server 2008 Expand / Collapse
Author
Message
Posted Sunday, March 06, 2011 11:13 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, January 28, 2013 11:06 PM
Points: 24, Visits: 86
Hi all,

i am using sql server 2008.

for auditing purpose triggers or best or Change data capture is best?

regarding performance issue which is the best one to use?
Post #1073953
Posted Sunday, March 06, 2011 11:34 PM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Monday, April 14, 2014 5:49 PM
Points: 2,263, Visits: 3,758
What are you planning to audit.

By the way, in SQL Server 2008 there is a new cool feature called AUDIT.

You will find it in Management Studio. You could plan to use it.


Mohammed Moinudheen
Post #1073959
Posted Monday, March 07, 2011 12:16 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, January 28, 2013 11:06 PM
Points: 24, Visits: 86
i have to audit changed data..

tell me which is best one(triggers or cdc) to use regarding performance issue..
Post #1073968
Posted Monday, May 02, 2011 3:43 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, February 05, 2014 10:27 AM
Points: 31, Visits: 374
Hi Moinu,

Is there anyway to purge the audit file based upon the time stamp?
Thanks,
Boj.
Post #1101992
Posted Monday, May 02, 2011 6:05 PM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, April 17, 2014 5:22 PM
Points: 1,192, Visits: 2,174
SQL Server 2008 has a new feature for Auditing. You can audit anything happening on the SQL Server using this feature. Its a full pledged Audit implementation and it's very granular. You can audit the select queries of as single user on a single table in a database. It's that granular. Also its very simple to implement. You can audit all the DDL, DML and server login activities.

Change Data Capture is also a very good feature of SQL 2008. It's available only in Enterprise edition. It can be used to track the DDL happening on the tables.

Triggers can also be used. But that require considerable effort on your part to code them properly. If not written properly they cause lot of headaches.

I'd prefer CDC to Triggers. BTW, what are you planning to achieve ?

Thank You,

Best Regards,
SQLBuddy

Post #1102024
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse