Auditing

Generic trigger for maintaining the Audit Log

  • Script

This trigger will work even if you don't have the primary key on any table. Mechanism to configure the primary key in config table has been provided. This can be very helpful to solve the system audit requirements without much efforts.

Disclaimer : Audit Log trigger has performance overhead. It’s meant for table which is not frequently updated, deleted or inserted. Please take precaution when creating the trigger on the table having too many columns.

2.33 (3)

2019-10-15 (first published: )

982 reads

Audit Users logging in using "sa" or service accounts

  • Script

Security is probably one of a production DBA's most important tasks and if developers use application or service accounts to run queries in your production environment you need to identify then and prohibit it. I notice some unwanted activity after staring a new job and decided to create a script that notifies me via email when […]

2019-07-04 (first published: )

1,261 reads

Blogs

Removing a Deleted Column from a Data Masker Masking Set

By

Data Masker for SQL Server is a great tool ensuring the data you use...

Containers: A Short Rant

By

I find myself doing more and more work with containers. Yet, I also find...

Daily Coping 20 Sep 2021

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Read the latest Blogs

Forums

Metadata-Data-Ratio in a table

By sean redmond

Hi all, My understanding about the structure of data within SQL Server is that...

Always On - why No failover occurred?

By onlo

Hi, I am using SQL 2016 (13.0.5888.11). Last Saturday (18th September), in non-office hours,...

Log Shipping Truncate Log File

By coolchaitu

Good Morning, I have read that taking a log backup truncates the log file....

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers