Trigger isn't working

• mballentine

  SSC Eights!

  Points: 884

  More actions

  October 16, 2026 at 6:27 pm

  #5067631

  Hi,

  I have a trigger, that works fine elsewhere but is not working at this location. At one point I put a print statement in the trigger just to see if it was firing. The message comes through, but the data is not being copied to the new table.

  USE [db name]
  GO
  /****** Object:  Trigger [dbo].[Front Temps]    Script Date: 10/16/2026 12:46:42 PM ******/
  SET ANSI_NULLS ON
  GO
  SET QUOTED_IDENTIFIER ON
  GO
  
  ALTER TRIGGER [dbo].[Front Temps]
     ON  [db name].[dbo].
     after INSERT
  AS 
  Begin
  SET NOCOUNT ON;
  
  INSERT INTO [db name].dbo.AlarmQueFront (CarId, ImageTime, FrontAlarmStatus, FrontAlarmTemp, Direction, TVImage, Images)
  SELECTi.[Car ID], 
  i.[Image Time],
  i.[Front Image Alarm Status],
  i.[Front High Temp],
  i.[Direction Label],
  dbo.[TorpedoVision Data Images].[Front Jpeg],
  i.[Images]
  FROM INSERTED as i
  INNER JOIN dbo.[db table name ]
  on dbo.[db table name].ID = i.Images
  
  WHERE i.[Front Image Alarm Status] <> '0'; 
  
  END