Send an alert when the database state changes to SQL Server single-user mode

(Nisarg Upadhyay) This article explains the SQL Server single-user mode and how to configure an automated email alert when the state of the user database changes to the single-user mode. To send an alert, we will create a DDL trigger that executes when the user runs the ALTER DATABASE query.

Register to Read