/****** Object:  Stored Procedure dbo.JMO_SBR_Del    Script Date: 12/1/2005 11:49:29 PM ******/


CREATE proc JMO_SBR_Del (
   @k_sbr_name      char(65)
)
as
begin
   Delete From jmo_sbr
   Where
       sbr_name         = @k_sbr_name

   Delete From jmo_swb
   Where
       swb_name         = @k_sbr_name

/* drop jbr and peripherals associated with set   */

   Delete From jmo_jbr
   Where
       jbr_scdn         = @k_sbr_name

   Delete From jmo_jwb
   Where
       jwb_scdn         = @k_sbr_name

   Delete From jmo_prb
   Where
       prb_scdn         = @k_sbr_name

/* drop PSRM where base key is equal to set   */

   Delete From jmo_psrm
   Where
       psr_scdn         = @k_sbr_name

/* drop psrm where pred set is equal to set    */

   Delete From jmo_psrm
   Where
       psr_pscd         = @k_sbr_name

end
GO
GRANT EXECUTE ON  [dbo].[JMO_SBR_Del] TO [emadmin]
GRANT EXECUTE ON  [dbo].[JMO_SBR_Del] TO [jmoadmin]
GRANT EXECUTE ON  [dbo].[JMO_SBR_Del] TO [uniadmin]
GO