Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
Log in  ::  Register  ::  Not logged in

Content with tags Auditing, T-SQL Rss

   Items 1 to 2 of 2   

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: | Category: t-sql
Rating: (not yet rated)  Rate this |   Briefcase | 3,848 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 | 2,956 reads
   Items 1 to 2 of 2   
sql server 2005 (1)