Auditing

External Article

Designing Tables for Audit Data in SQL Server

  • Article

My company is just starting to look at adding functionality to retain historical data for key tables and columns for auditing purposes in many of our SQL Server databases. I have seen some of your recent tips related to triggers (Forcing Trigger Firing Order in SQL Server and Trigger Alternatives in SQL Server - OUTPUT Clause). Based on using triggers or a similar technology, what is the best way to store the historical data?

2008-04-15

5,915 reads

SQLServerCentral Article

Monitoring and Recording DDL changes on SQL 2005 (NARC)

  • Article

Auditing activities on your database servers becomes more important all the time. But ensuring that schema changes do not occur without your knowledge may be more important for a stable system. James Greaves brings us a great technique using DDL triggers for doing this.

4.52 (21)

You rated this post out of 5. Change rating

2008-02-29

7,476 reads

Blogs

T-SQL Tuesday #183 Roundup

By

I hosted this month’s T-SQL Tuesday party with my invitation asking about tracking permissions....

A Little Brainstorming with an AI

By

I was asked to do some a little thinking and brainstorming recently. Rather than...

The Mysterious Empty Table

By

It seems like no matter how long you work with a system beyond a...

Read the latest Blogs

Forums

how do you manage new columns in a tabular table

By stan

Hi we run 2019 ssas std.  Yesterday i imported my tabular project to vs...

Why I get null instead I should get 0

By hilme70

Code for mssql 2008 DECLARE @CompanyID TINYINT DECLARE @MemNo decimal DECLARE @MemberFrom Integer DECLARE...

bypass a non existing server

By mtz676

I have an execute task(has server list from a table) pointing to foraeachloop foreachloop...

Visit the forum

Question of the Day

Mixed Backups

I have a complex database with a few filegroups and files. Can I run a backup command like this? (assume file/filegroup names are valid).

BACKUP DATABASE [complex]
    FILE = N'thirdone'
 ,  FILE = N'thirdtwo'
 ,  FILEGROUP = N'second' 
 TO  DISK = N'C:\Program Files\Microsoft SQL Server\MSSQL16.SQL2022\MSSQL\Backup\complex.bak' 
 WITH NOFORMAT, NOINIT,  NAME = N'complex-Full Database Backup', SKIP, NOREWIND, NOUNLOAD,  STATS = 10
GO

See possible answers