problem to deploy trigger in Deployment Toolkit


Author
Message
Raymond Lo
Raymond Lo
StrataFrame Beginner (28 reputation)StrataFrame Beginner (28 reputation)StrataFrame Beginner (28 reputation)StrataFrame Beginner (28 reputation)StrataFrame Beginner (28 reputation)StrataFrame Beginner (28 reputation)StrataFrame Beginner (28 reputation)StrataFrame Beginner (28 reputation)StrataFrame Beginner (28 reputation)
Group: Forum Members
Posts: 18, Visits: 101
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.


GO

Merge Selected

Merge into selected topic...



Merge into merge target...



Merge into a specific topic ID...





Similar Topics

Reading This Topic

Login

Explore
Messages
Mentions
Search