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



CREATE proc JMO_SBR_DelY (
   @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

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