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,033 reads

Blogs

T-SQL Tuesday #180: Good enough is perfect Roundup

By

This month, I prompted bloggers to discuss whether good enough is perfect. Thank you to all...

Using SQL Compare with Read-only Access

By

Recently a customer asked if SQL Compare and SQL Data Compare can be used...

Off to Live 360

By

I am off to Live 360 today, on my last trip of the year....

Read the latest Blogs

Forums

Immediate Recap: Pounds 124, Clippers 117

By Emanis

No person would create the situation that a eye-catching video game of basketball was...

NFC Wild Card Breakdown: Cowboys vs. Packers

By Emanis

The Fresh Orleans Saints are shed the playoffs for the 3rd instantly time, which...

how can i tell if our db2 driver is ms or ibm or other?

By stan

i see this in the definition of a linked server on our wh sql...

Visit the forum

Question of the Day

A Strange Result

What does this code return in SSMS 20 from SQL Server 2019?

select '|' + CHAR(0)+'abc' + '|';

See possible answers