Trying and failing to create a trigger which deletes all of the jobs associated with a database when someone invokes the following command:

DROP DATABASE databaseName

I've tried accessing the ObjectName field in EVENTDATA but i keep getting nulls. almost at the end of my tether!

#SQLHelp #SQLServer #SQLSupport