数据库级触发器,防止删库。
CREATE TRIGGER [TR_CannotDropDatabase] ON ALL SERVER FOR DROP_DATABASE
as
BEGIN
PRINT '不能删除此数据库'
ROLLBACK TRANSACTION
END
GO
SET ANSI_NULLS OFF
GO
SET QUOTED_IDENTIFIER OFF
GO
ENABLE TRIGGER [TR_CannotDropDatabase] ON ALL SERVER
测试:
感谢bright