2021-04-13
603 reads
2021-04-13
603 reads
2019-04-25
630 reads
2015-11-27
1,233 reads
2013-12-02 (first published: 2013-11-18)
1,698 reads
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)
1,506 reads
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.
2013-06-10
2,988 reads
In this tip Aaron Bertrand describes some of the ways in which you can extend the DDL trigger functionality.
2013-05-30
4,116 reads
2012-01-18
2,252 reads
Using a DDL trigger, two schemas and a stored procedure recycle bin functionality can be create in SQL Server.
2009-05-20
13,336 reads
How to use DDL triggers and Query the Data with minimum performance impact.
2008-10-02
1,804 reads
Since witnessing a rather nasty cyber attack around a year ago, I’ve been thinking...
By Steve Jones
My slides are here: VCS Primer Denver 2023 This was an overview of what...
By Steve Jones
The Future Data Driven 2023 virtual conference is coming on Wednesday, September 27. Register...
Hi All, I installed reporting services evaluation edition for testing purpose, but now 180...
Hi Everyone, Why and when should be set 'cost threshold for parallelism'? We are...
Dears, In my company, we have certain master data domains like customer; Vendor; Product;...