--==================================== -- Create server trigger template --==================================== IF EXISTS( SELECT * FROM sys.server_triggers WHERE name = N'' AND parent_class_desc = N'SERVER' ) DROP TRIGGER ON ALL SERVER GO CREATE TRIGGER DBA_CHECKER ON ALL SERVER FOR AS IF IS_MEMBER ('db_owner') = 0 BEGIN PRINT 'You must ask your DBA to drop or alter databases!' ROLLBACK TRANSACTION END GO