problem to deploy trigger in Deployment Toolkit

Raymond Lo — Thu, 12 Feb 2009 10:41:31 GMT

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.

RE: problem to deploy trigger in Deployment Toolkit

Dustin Taylor — Thu, 12 Feb 2009 10:41:31 GMT

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

Thanks! :)

StrataFrame Forum » StrataFrame Database Deployment Toolkit » Database Deployment Toolkit (How do I?) » problem to deploy trigger in Deployment Toolkit

problem to deploy trigger in Deployment Toolkit

RE: problem to deploy trigger in Deployment Toolkit