[MSSQL]禁止删库

数据库级触发器，防止删库。

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