Add user with DDL Trigger
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,641 reads
DDL trigger
Extend SQL Server DDL Triggers for more functionality: Part 2
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
Extending SQL Server DDL Triggers for More Functionality
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,278 reads
Creating a recycle bin for SQL Server 2005\2008
Using a DDL trigger, two schemas and a stored procedure recycle bin functionality can be create in SQL Server.
2009-05-20
13,756 reads
DDL Triggers Implementation
How to use DDL triggers and Query the Data with minimum performance impact.
2008-10-02
1,839 reads
2012-07-17 (first published: 2007-11-21)
2,272 reads
Blogs
A Last Minute Trip to the EU
By Steve Jones
My life has some crazy travel stretches for sure. Between speaking, office visits, customer...
Part 3 of 3: Tuning DiskANN — R, Alpha, L, Beam Width, Recall and Latency
In Part 1, we saw how ‘Vamana’ represents vectors as nodes, connects them with...
Automated SQL Server Benchmarking with HammerDB and Docker: A Complete Testing Framework
I’m excited to announce the release of a new open-source project that fully automates...
Forums
Marshall??????????
??????????,??????????????????????????????MARSHALL ????????????????,??????????????????????????,??????????????????????? MARSHALL ?????????? ???? MARSHALL ???,?????????????,???????????????????????????????????,??????????????????????? ?????,??????????????,?????????????????????? ???????????? ??????????,????????????????????,?????????????????????????? MARSHALL ??????????????,????????????? ??????????????,???????????????????????? ????????????...
Server-Level Table sizes
Comments posted to this topic are about the item Server-Level Table sizes
Question of the Day
ORDER BY alias
There is a table tmp_tab:
CREATE TABLE tmp_tab ( id int, val int );
INSERT INTO tmp_tab VALUES (1, 1), (2, NULL), (3, 3), (4, 4), (5, 5);You want to order the rows ids by the following expression:
ISNULL(val, id) + 1Which of the following queries produces the expected ordering and why? (Select all correct) See possible answers