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