SQLServerCentral: Content tagged Auditing, T-SQL

Auditing DDL Actions

Audit data using SQL Server 2005's COLUMNS_UPDATED function

Auditing data changes in your production environment is very important, especially if you are dealing with confidential information. Read more...

By Additional Articles 2008/10/23 | Source: Builder.com | Category: t-sql

Rating: (not yet rated) Rate this |

Briefcase | 4,025 reads

SqlCredit – Part 17: Exploring SQL 2005’s OUTPUT Clause

SQL Server 2005 introduces the OUTPUT clause, a bit of magic that allows us to get the identity value, plus a number of other values, from an INSERT, UPDATE, or DELETE, which all have different interaction with OUTPUT. This article concentrates on INSERT. Read more...

By Additional Articles 2008/08/04 | Source: Database Journal | Category: auditing

Rating:

Rate this |

Briefcase | 3,159 reads

Content with tags Auditing, T-SQL

Auditing DDL Actions

Audit data using SQL Server 2005's COLUMNS_UPDATED function

SqlCredit – Part 17: Exploring SQL 2005’s OUTPUT Clause