Automate Audit Trigger Generation

I have been tasked with a daunting job of scripting I/U/D triggers for our new database. The job of the triggers is to Audit the activity on the tables. What column was changed to what value on what table and by whom. With over 60 tables, this is a daunting task. So off I went […]

5 (2)

2004-02-24

998 reads

Blogs

What the ???? T-SQL Tuesday #120

By

Hey, it’s T-SQL Tuesday again! I almost forgot about it what with Summit and...

First Time Speaking at PASS Summit

By

This week, I filmed my experience as a first time speaker at PASS Summit...

Azure SQL Best Practices?

By

A way to enforce good practice and standards is by Azure Policy. As stated...

Read the latest Blogs

Forums

SQL View - Pivot

By bbranco

I have the following data in a table, its pricing for items, so if...

does WITH (NOLOCK) hint in Select statement really make a difference?

By VoldemarG

In any regular Select query joining a few tables like below, does using this...

Query

By jsshivalik

Hi Table 1 AccountId Name 1101 aaaa 1701 bbbb Table 2 TransId Account Debit...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers