2024-09-16
366 reads
2024-09-16
366 reads
2021-04-13
617 reads
2019-04-25
637 reads
2015-11-27
1,236 reads
2013-12-02 (first published: 2013-11-18)
1,709 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,583 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,255 reads
Using a DDL trigger, two schemas and a stored procedure recycle bin functionality can be create in SQL Server.
2009-05-20
13,630 reads
This article provides a comprehensive overview of the ORDER BY clause within SQL window...
Want to build a data analytics foundation that transforms raw data into valuable business...
By Steve Jones
Recently a customer asked if SQL Compare and SQL Data Compare can be used...
I'm using the below connection string using providing UserID and password on their respective...
Comments posted to this topic are about the item Knowing Your Total Reward