if exists(select * from sysobjects where name = 'trgg_ggm01_before' and type = 'TR')
begin
    drop trigger trgg_ggm01_before
end
go

create trigger [dbo].[trgg_ggm01_before]
on [dbo].[ggm01]  
instead of insert,delete,update
as
begin
      raiserror('老系统已经停止使用',18,1)
end
GO

if exists(select * from sysobjects where name = 'trgg_ggm02_before' and type = 'TR')
begin
    drop trigger trgg_ggm02_before
end
go

create trigger [dbo].[trgg_ggm02_before]
on [dbo].[ggm02]  
instead of insert,delete,update
as
begin
	  raiserror('老系统已经停止使用',18,1)
end


GO


if exists(select * from sysobjects where name = 'trgg_ggm03_before' and type = 'TR')
begin
    drop trigger trgg_ggm03_before
end
go

create trigger [dbo].[trgg_ggm03_before]
on [dbo].[ggm03]  
instead of insert,delete,update
as
begin
	  raiserror('老系统已经停止使用',18,1)
end

GO

if exists(select * from sysobjects where name = 'trgg_gnm01_before' and type = 'TR')
begin
    drop trigger trgg_gnm01_before
end
go

create trigger [dbo].[trgg_gnm01_before]
on [dbo].[gnm01]  
instead of insert,delete,update
as
begin
      raiserror('老系统已经停止使用',18,1)
end
GO

if exists(select * from sysobjects where name = 'trgg_gnm02_before' and type = 'TR')
begin
    drop trigger trgg_gnm02_before
end
go

create trigger [dbo].[trgg_gnm02_before]
on [dbo].[gnm02]  
instead of insert,delete,update
as
begin
	  raiserror('老系统已经停止使用',18,1)
end


GO