if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[UpdateSanadStandard]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[UpdateSanadStandard]


if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[CreateSanadStandard]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[CreateSanadStandard]


if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TI_SanadStandard]') and OBJECTPROPERTY(id, N'IsTrigger') = 1)
Drop Trigger [dbo].[TI_SanadStandard]