StrataFrame Forum

problem to deploy trigger in Deployment Toolkit

http://forum.strataframe.net/Topic21925.aspx

By Raymond Lo - 2/12/2009

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.

By Dustin Taylor - 2/12/2009

What is the text of the error message? The image was resized down and I can't read the contents of it.

Thanks! Smile