SQL Server/T-SQL Tutorial/Trigger/Trigger on server

Creating a DDL Trigger that Audits Server-Level Events

4>
5> USE master
6> GO
Changed database context to "master".
1> -- Disallow new Logins on the SQL instance
2> CREATE TRIGGER trg_RestrictNewLogins
3> ON ALL SERVER
4> FOR CREATE_LOGIN
5> AS
6> PRINT "No login creations without DBA involvement."
7> ROLLBACK
8> GO
1>
2> CREATE LOGIN JoeS WITH PASSWORD = "Password"
3> GO
Msg 15118, Level 16, State 1, Server BCE67B1242DE45A\SQLEXPRESS, Line 2
Password validation failed. The password does not meet Windows policy requirements because it is not complex enough.
1>
2> drop trigger trg_RestrictNewLogins
3> GO
Msg 3701, Level 11, State 5, Server BCE67B1242DE45A\SQLEXPRESS, Line 2
Cannot drop the trigger "trg_RestrictNewLogins", because it does not exist or you do not have permission.