Extremely slow SQL server

• Sergiy

  SSC Guru

  Points: 110206

  More actions

  March 15, 2018 at 6:11 am

  #1983361

  troys - Tuesday, March 13, 2018 4:26 AM

  
ALTER TRIGGER [dbo].[trig_Manifest_Delete] ON [dbo].[ManifestDetail]
  FOR DELETE
  AS
  Begin 
  DECLARE @ManType INT;
  SELECT @ManType=ISNULL(MH.ManifestType,0) FROM Inserted i
  ......

  Table Inserted is always empty in DELETE trigger.
  Did anybody ever test the code?

  _____________
  Code for TallyGenerator