注

一般是微信会员没有部署好，或者需要停用微信会员的触发器

 if exists(select 1 from dbo.sysobjects  where id = object_id(N'[dbo].[TR_BAS_SHP_Wechat_update]')   and OBJECTPROPERTY(id, N'IsTrigger') = 1)
begin	drop trigger TR_BAS_SHP_Wechat_update end
 if exists(select 1 from dbo.sysobjects  where id = object_id(N'[dbo].[TR_BAS_SHP_Wechat_insert]')   and OBJECTPROPERTY(id, N'IsTrigger') = 1)
begin	drop trigger TR_BAS_SHP_Wechat_insert end
if exists(select 1 from dbo.sysobjects  where id = object_id(N'[dbo].[TR_Bas_VIP_Wechat]')   and OBJECTPROPERTY(id, N'IsTrigger') = 1)
begin	drop trigger TR_Bas_VIP_Wechat end
if exists(select 1 from dbo.sysobjects  where id = object_id(N'[dbo].[TR_Bas_VIP_KIND_Wechat]')   and OBJECTPROPERTY(id, N'IsTrigger') = 1)
begin	drop trigger TR_Bas_VIP_KIND_Wechat end
if exists(select 1 from dbo.sysobjects  where id = object_id(N'[dbo].[TR_Bas_VIP_weixin_Wechat]')   and OBJECTPROPERTY(id, N'IsTrigger') = 1)
begin	drop trigger TR_Bas_VIP_weixin_Wechat end
 if exists(select 1 from dbo.sysobjects  where id = object_id(N'[dbo].[TR_BAS_SHP_Wechat]')   and OBJECTPROPERTY(id, N'IsTrigger') = 1)
begin	drop trigger TR_BAS_SHP_Wechat end
 if exists(select 1 from dbo.sysobjects  where id = object_id(N'[dbo].[TR_Dat_gtss_Wechat_TempMsg]')   and OBJECTPROPERTY(id, N'IsTrigger') = 1)
begin	drop trigger TR_Dat_gtss_Wechat_TempMsg end
  if exists(select 1 from dbo.sysobjects  where id = object_id(N'[dbo].[TR_ACC_VIP_INTEGAL_Wechat_TempMsg]')   and OBJECTPROPERTY(id, N'IsTrigger') = 1)
begin	drop trigger TR_ACC_VIP_INTEGAL_Wechat_TempMsg end
if exists(select 1 from dbo.sysobjects  where id = object_id(N'[dbo].[TR_Card_AddMoney_Wechat_TempMsg]')   and OBJECTPROPERTY(id, N'IsTrigger') = 1)
begin	drop trigger TR_Card_AddMoney_Wechat_TempMsg END
if exists(select 1 from dbo.sysobjects  where id = object_id(N'[dbo].[TR_Dat_VipCardCkrk_Wechat_TempMsg]')   and OBJECTPROPERTY(id, N'IsTrigger') = 1)
begin	drop trigger TR_Dat_VipCardCkrk_Wechat_TempMsg END
if exists(select 1 from dbo.sysobjects  where id = object_id(N'[dbo].[TR_Bas_VIP_Wechat_insert]')   and OBJECTPROPERTY(id, N'IsTrigger') = 1)
begin	drop trigger TR_Bas_VIP_Wechat_insert END
if exists(select 1 from dbo.sysobjects  where id = object_id(N'[dbo].[TR_Bas_VIP_Wechat_update]')   and OBJECTPROPERTY(id, N'IsTrigger') = 1)
begin	drop trigger TR_Bas_VIP_Wechat_update END
if exists(select 1 from dbo.sysobjects  where id = object_id(N'[dbo].[TR_Bas_VIP_KIND_Wechat_Update]')   and OBJECTPROPERTY(id, N'IsTrigger') = 1) begin	drop trigger TR_Bas_VIP_KIND_Wechat_Update END
if exists(select 1 from dbo.sysobjects  where id = object_id(N'[dbo].[TR_Bas_VIP_KIND_Wechat_insert]')   and OBJECTPROPERTY(id, N'IsTrigger') = 1) begin	drop trigger TR_Bas_VIP_KIND_Wechat_insert END
if exists(select 1 from dbo.sysobjects  where id = object_id(N'[dbo].[TR_Dat_gtss_Wechat_UpdatePay]')   and OBJECTPROPERTY(id, N'IsTrigger') = 1) begin	drop trigger TR_Dat_gtss_Wechat_UpdatePay END
if exists(select 1 from dbo.sysobjects  where id = object_id(N'[dbo].[TR_bas_vip_weixin_Wechat_update]')   and OBJECTPROPERTY(id, N'IsTrigger') = 1) 
begin
	drop trigger TR_bas_vip_weixin_Wechat_update 
END
if exists(select 1 from dbo.sysobjects  where id = object_id(N'[dbo].[TR_bas_vip_weixin_Wechat_insert]')   and OBJECTPROPERTY(id, N'IsTrigger') = 1) 
begin
	drop trigger TR_bas_vip_weixin_Wechat_insert 
END