Hello,



I'm trying to create a simple trigger on Delete using the Database Deployment ToolKit but when I attempt to deploy it I get:

Column tr_Schema does not belong to table DBETrigers



Have I missed something? The following is the body of the trigger. Thanks in advance for the help:





AFTER DELETE

AS

BEGIN



-- Prevent the result count from interfering

SET NOCOUNT ON;



-- Add trigger logic here

   if exists (Select 1 from Music m,deleted t

      where m.Artist_fk = t.Artist_pk)

      Begin

         goto error

      End

   return

error:

   raiserror 30006, 'Children exist in Music. Cannot delete this record'

END


Cory Cookson

Software Developer

Occupational Health Research

Spoke too soon. The DDT deletes triggers with no error message but I still get the error when trying to add a trigger.

That column that is specified is no longer in use.  So either your data structures are not updated and that column still exists and/or the tr_schema column exists within your PKG file and just needs to be rebuilt.  So start by looking at your data structures in the StrataFrame database in teh DBETriggers table.  The structure should look like this: