Preventing Trigger Execution
- QotD Question
Dynamically generate trigger DDL and write to individual SQL files.
2013-12-02 (first published: 2013-11-18)
DDL trigger will add a user to a newly created database and assign db_owner role. It can be modified for what role is required.
2015-03-12 (first published: 2013-08-22)
A previous tip, SQL Server DDL Triggers to Track All Database Changes, generated a lot of discussion involving ways to make the provided DDL trigger more useful. Check out this tip to expand your knowledge on DDL Triggers.
In this tip Aaron Bertrand describes some of the ways in which you can extend the DDL trigger functionality.
Using a DDL trigger, two schemas and a stored procedure recycle bin functionality can be create in SQL Server.
How to use DDL triggers and Query the Data with minimum performance impact.
This is part of a series of new job blog posts. You can find...
By Will Assaf
SQL Server 2022 Administration Inside Out is now available for pre-order from Microsoft Press. This...
Back in December 2019, I started presenting my session on mental health with lots...
what I want is to apply some filter patterns to search the data. For...
Hi All, Using Tsql query I want to know currently running sql agent jobs...
Hi All, Want to know what are the SQL Agent Jobs scheduled for today...
SQL Server Q&A from the SQLServerCentral communityGet answers