IF EXISTS
(
    SELECT *
    FROM dbo.sysobjects
    WHERE id = OBJECT_ID(N'[dbo].[TU_HamrahDrug]')
          AND OBJECTPROPERTY(id, N'IsTrigger') = 1
)
    DROP TRIGGER [dbo].[TU_HamrahDrug];


IF EXISTS
(
    SELECT *
    FROM dbo.sysobjects
    WHERE id = OBJECT_ID(N'[dbo].[TI_HamrahDrug]')
          AND OBJECTPROPERTY(id, N'IsTrigger') = 1
)
    DROP TRIGGER [dbo].[TI_HamrahDrug];