Click here to Skip to main content
Rate this: bad
Please Sign up or sign in to vote.
See more: SQL-server-2008R2
I want to implement audit trail in sql server 2008 r2 in express edition. any one know how to implement the same.
Thanks a lot in advance.
Posted 26-Dec-12 18:58pm

1 solution

Rate this: bad
Please Sign up or sign in to vote.

Solution 1

As you are aware, SQL Server Audit can only be done on Enterprise and Data center editions of SQL Server 2008 R2.
However, the article mentioned above briefly mentions SQL Server Trace (SQL Profiler is the GUI). SQL Server Trace can be used to trace all batches that run on your server. This will give you a good degree of auditing, although not at the level that the SQL Server Audit provides. There have been articles on this:
And others as well. People used SQL Server Trace and Profiler for years before SQL Server Audit and doubtless many who cannot afford the more expensive versions of SQL Server will continue to do so.
Happy New Year ... Wish u good luck...Smile | :)
Nirali R shah at 27-Dec-12 1:55am
Thank you very much for your quick reply.. so can i implement Audit with the triggers...if so then how?
Wishing you Happy New Year :)
Nirali R shah at 27-Dec-12 7:40am
I want your help for SQL Server 2008 r2 Express to implement Audit, where it is done manually or is there any inbuilt functionality for the same..

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
0 OriginalGriff 370
1 Prakriti Goyal 177
2 Sergey Alexandrovich Kryukov 155
3 jlopez788 134
4 _Amy 110
0 OriginalGriff 6,762
1 Sergey Alexandrovich Kryukov 5,539
2 Maciej Los 3,479
3 Peter Leow 3,323
4 DamithSL 2,505

Advertise | Privacy | Mobile
Web01 | 2.8.140721.1 | Last Updated 27 Dec 2012
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100