sqlserver 数据库触发器
create trigger [Tran_alterschemaonly] on database for ALTER_FUNCTION,ALTER_PROCEDURE as
?? ??? ??? ??? ??? ??? ??? ?set ANSI_NULLS ON ?? ??? ??? ??? ??? ??? ??? ?set ANSI_PADDING ON ?? ??? ??? ??? ??? ??? ??? ?set ANSI_WARNINGS ON ?? ??? ??? ??? ??? ??? ??? ?set ARITHABORT ON ?? ??? ??? ??? ??? ??? ??? ?set CONCAT_NULL_YIELDS_NULL ON ?? ??? ??? ??? ??? ??? ??? ?set NUMERIC_ROUNDABORT OFF ?? ??? ??? ??? ??? ??? ??? ?set QUOTED_IDENTIFIER ON ?? ??? ??? ??? ??? ??? ??? ?declare @EventData xml ?? ??? ??? ??? ??? ??? ??? ?set @EventData=EventData()?? ? ?? ??? ??? ??? ??? ??? ??? ?exec sys.sp_MStran_ddlrepl @EventData,3 GO create trigger [Tran_altertable] on database for ALTER_TABLE as ?? ??? ??? ??? ??? ??? ??? ?set ANSI_NULLS ON ?? ??? ??? ??? ??? ??? ??? ?set ANSI_PADDING ON ?? ??? ??? ??? ??? ??? ??? ?set ANSI_WARNINGS ON ?? ??? ??? ??? ??? ??? ??? ?set ARITHABORT ON ?? ??? ??? ??? ??? ??? ??? ?set CONCAT_NULL_YIELDS_NULL ON ?? ??? ??? ??? ??? ??? ??? ?set NUMERIC_ROUNDABORT OFF ?? ??? ??? ??? ??? ??? ??? ?set QUOTED_IDENTIFIER ON ?? ??? ??? ??? ??? ??? ??? ?declare @EventData xml ?? ??? ??? ??? ??? ??? ??? ?set @EventData=EventData()?? ? ?? ??? ??? ??? ??? ??? ??? ?exec sys.sp_MStran_ddlrepl @EventData,1 GO create trigger [Tran_altertrigger] on database for ALTER_TRIGGER as ?? ??? ??? ??? ??? ??? ??? ?set ANSI_NULLS ON ?? ??? ??? ??? ??? ??? ??? ?set ANSI_PADDING ON ?? ??? ??? ??? ??? ??? ??? ?set ANSI_WARNINGS ON ?? ??? ??? ??? ??? ??? ??? ?set ARITHABORT ON ?? ??? ??? ??? ??? ??? ??? ?set CONCAT_NULL_YIELDS_NULL ON ?? ??? ??? ??? ??? ??? ??? ?set NUMERIC_ROUNDABORT OFF ?? ??? ??? ??? ??? ??? ??? ?set QUOTED_IDENTIFIER ON ?? ??? ??? ??? ??? ??? ??? ?declare @EventData xml ?? ??? ??? ??? ??? ??? ??? ?set @EventData=EventData()?? ? ?? ??? ??? ??? ??? ??? ??? ?exec sys.sp_MStran_ddlrepl @EventData,4 GO create trigger [Tran_alterview] on database for ALTER_VIEW as ?? ??? ??? ??? ??? ??? ??? ?set ANSI_NULLS ON ?? ??? ??? ??? ??? ??? ??? ?set ANSI_PADDING ON ?? ??? ??? ??? ??? ??? ??? ?set ANSI_WARNINGS ON ?? ??? ??? ??? ??? ??? ??? ?set ARITHABORT ON ?? ??? ??? ??? ??? ??? ??? ?set CONCAT_NULL_YIELDS_NULL ON ?? ??? ??? ??? ??? ??? ??? ?set NUMERIC_ROUNDABORT OFF ?? ??? ??? ??? ??? ??? ??? ?set QUOTED_IDENTIFIER ON ?? ??? ??? ??? ??? ??? ??? ?declare @EventData xml ?? ??? ??? ??? ??? ??? ??? ?set @EventData=EventData()?? ? ?? ??? ??? ??? ??? ??? ??? ?exec sys.sp_MStran_ddlrepl @EventData,2 GO (编辑:李大同) 【声明】本站内容均来自网络,其相关言论仅代表作者个人观点,不代表本站立场。若无意侵犯到您的权利,请及时与联系站长删除相关内容! |