CODEWITHSUNDEEP
sql-server-2008
user266044
user266044

Reputation: 1

sql-server-2008 audit tables

In one of my application Iam using SQL SERVER 2008, I like to implement audit tables for few tables. One option I have to create triggers on the respective tables. Can anyone suggest me any other good, robust and secure option.

Upvotes: 0

Views: 1499

Answers (3)

Tony
Tony

Reputation: 10357

You don't mentione which edition of SQL Server you are using as the Auditing features are only available in the Enterprise edition.

You should download a copy of the free eBook Developing Time-Oriented Database Applications in SQL by Richard T. Snodgrass from here: http://www.cs.arizona.edu/people/rts/tdbbook.pdf.

He talks about auditing and many other time related issues in databases.

Upvotes: 0

Frank Kalis
Frank Kalis

Reputation: 1352

Triggers are the usual way to go. Another option could be to handle this in your stored procedures. Of course this assumes, that all data modification goes via stored procedure. Since you are on SQL Server 2008 and assuming you don't care about any lower version, check out the new auditing features here: http://msdn.microsoft.com/en-us/library/dd392015.aspx

Upvotes: 0

Mitch Wheat
Mitch Wheat

Reputation: 300797

SQL Server 2008 has a new auditing feature: Auditing in SQL Server 2008.

There is also Change Data Capture

Upvotes: 1

Related Questions