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

I checked DBETriggers and it contained the correct columns so I assumed that the problem had to be with DatabaseDTK.exe. Next I un-installed SF, re-booted, and re-installed SF. I had done this previously but this time I ran a search for DatabaseDTK.exe prior to installing and found a file named DatabaseDTK.exe-... in the Windows.Prefetch directory. I deleted the file, re-instaled SF, and everything now works as it should Is it possbile that the file in Windows.Prefetch causes problems with the install?

Yes.  It would change how the PKG file would be produced which would cause the DBEngine (DatabaseMigrator class) to fail.  So hopefully that was all it was!  If it is deploying now, then you should be in good shape.