Monitor user-defined function

SQL Server Administration
6

But why create a trigger? Why not implement some change control.
Check out check in code code review and deploy only approved code

Your source control becomes you audit trail