Tag Archives: triggers

  1. Audit Columns


    September 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

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


    November 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

  3. Setting Trigger Order

    Leave a comment

    August 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

  4. Disabling and enabling triggers


    March 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

  5. Can we get a license for DDL Triggers?


    December 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

  6. Tales of a DBA fed up with NOLOCK. Part 1


    February 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

  7. Triggers are not toys!


    September 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

Enter your email address to follow this blog and receive notifications of new posts by email.

Join 3,753 other subscribers

Follow me on Twitter

ToadWorld Pro of the Month November 2013