Racism sucks. I know, I've lived in Texas all my life and have seen it over and over. India certainly isn't the only country the racists have targeted. Mexico got its share during NAFTA and after. China has been the brunt of comments for decades, maybe
centuries. I always wonder if it will EVER end.
Anyone that would make a comment to Anand in a racist manner, doesn't have a clue about him. Which reminds me, he tagged me...
Isn't Drop Trigger a ddl event. How did it execute without firing the trigger?
Permissions of course!!!
To drop a DML trigger requires ALTER permission on the table or view on which the trigger is defined.
To drop a DDL trigger defined with server scope (ON ALL SERVER) requires CONTROL SERVER permission in the server. To drop a DDL trigger defined with database scope (ON DATABASE) requires ALTER ANY DATABASE DDL TRIGGER permission in the current database.
Be careful with making any changes to this behavior. I don't want to get a call that someone has painted themselves into a corner. [C]
A similar DDL trigger example is provided with the AdventureWorks sample database. To obtain the example, find the Database Triggers folder in the SQL Server Management Studio Object Explorer, located under the Programmability folder of the
AdventureWorks database. Right-click ddlDatabseTriggerLog and select "Script Database Trigger as". By default, DDL trigger
ddlDatabseTriggerLog is disabled.