Tag Archives: triggers
-
Audit Columns
3September 28, 2021 by Kenneth Fisher
One of the easiest ways to collect information about table activity is to add a series of audit columns to …
Continue reading -
What the ???? T-SQL Tuesday #120
11November 12, 2019 by Kenneth Fisher
Hey, it’s T-SQL Tuesday again! I almost forgot about it what with Summit and all. Wayne Sheffield (blog|twitter) is our …
Continue reading -
Setting Trigger Order
Leave a commentAugust 26, 2019 by Kenneth Fisher
If you can help it you probably shouldn’t be using triggers. But if you have to use a trigger you …
Continue reading -
Disabling and enabling triggers
2March 6, 2019 by Kenneth Fisher
I tend to feel that a lot of people who use triggers don’t really understand them. That said, every now …
Continue reading -
Can we get a license for DDL Triggers?
4December 14, 2015 by Kenneth Fisher
There are several types of triggers. Logon triggers – Fired when someone tries to connect to the instance. DML triggers …
Continue reading -
Tales of a DBA fed up with NOLOCK. Part 1
44February 16, 2015 by Kenneth Fisher
Nov 12, 2014 Dear Diary, They asked for help again. Every now and again everything slows down and they see …
Continue reading -
Triggers are not toys!
9September 17, 2014 by Kenneth Fisher
For the love of all that’s SQL, triggers are not toys! I’m not even talking about logon triggers or DDL …
Continue reading
SQL Studies 