Tag Archives: Triggers

Capturing Extended Properties on Drop Table

Posted on March 6, 2021 by thomasrushton

TL;DR – Nope. Extended Properties Custom extended properties can be a useful tool when creating a self-documenting database. However, in an environment where tables are routinely dropped and recreated by software/systems not within your control, it may be desirable to … Continue reading →

Posted in Uncategorized | Tagged , , , | 2 Comments

Shooting Yourself In The Foot While Testing Triggers, or The Importance of GO

Posted on February 27, 2021 by thomasrushton

No, not “Go” the game… I was working on some functionality for a create table trigger. I had the whole creation / testing thing wrapped up in a single script for easy testing and possible deployment across multiple databases: All … Continue reading →

Posted in Uncategorized | Tagged , | 1 Comment