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