【单选题】创建触发器TR_DDL,禁止在SQL Server服务器里删除数据库XSGL,下列正确的操作是()
A、CREATE TRIGGER TR_DDL ON ALL SERVER FOR DROP_DATABASE AS print '对不起,您不能删除数据库,请联系dba' rollback transaction --在查询窗口中执行激活触发器的SQL语句:DROP DATABASE xsgl
B、CREATE TRIGGER TR_DDL ON DATABASE FOR DROP_DATABASE AS print '对不起,您不能删除数据库,请联系dba' rollback transaction --在查询窗口中执行激活触发器的SQL语句:DROP DATABASE xsgl
C、CREATE TRIGGER TR_DDL ON ALL SERVER AS print '对不起,您不能删除数据库,请联系dba' rollback transaction --在查询窗口中执行激活触发器的SQL语句:DROP DATABASE xsgl
D、CREATE TRIGGER TR_DDL ON ALL SERVER FOR DROP AS print '对不起,您不能删除数据库,请联系dba' rollback transaction --在查询窗口中执行激活触发器的SQL语句:DROP DATABASE xsgl