Technical Article

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)

You rated this post out of 5. Change rating

2004-02-24

1,029 reads

Blogs

Familiar Sights

By

Yesterday was a long day in London. I arrived late in the am, and...

Derby City Data Days

By

It was awesome to see the Kentucky data community come out for the first...

Tomorrow: Webcast on SQL Server security

By

Tomorrow, April 16, 2024, I will be giving another webcast; this one will be...

Read the latest Blogs

Forums

Difference between equal directly and use SUBSTRING

By Martass

Hello, I have a script that was running really long, and I have found...

Visualisation options as an alternative to SanKey diagram

By aaron.reese

I am building a report to show customer journeys and their arrears levels. I...

should i prefer join or left join over exists or in

By rajemessage 14195

hi, I have seen people use exists when exists is required and no cols...

Visit the forum

Question of the Day

Express In-Memory OLTP

Can I create In-Memory OLTP tables in SQL Server Express?

See possible answers