Hi,
I have a problem to deploy a triger in DDT, my trigger code as bellow:
====================================
AFTER INSERT
set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
AS
BEGIN
-- Prevent the result count from interfering
SET NOCOUNT ON;
-- Add trigger logic here
declare @curid int, @curcode nchar(5), @cureffectivedate smalldatetime, @currate smallmoney, @lastuser nvarchar(25)
select @curid=curid, @curcode=curcode, @cureffectivedate=cureffectivedate, @currate=currate, @lastuser=lastuser from inserted
insert into exchangerate values (@curcode, @curid, @cureffectivedate, @currate, @lastuser, getdate())
END
=============
too simple but I don't know why can not to delpoy it, the error message as bellow.