USP_DELETE_CRMBBENVIRONMENT

create proc USP_DELETE_CRMBBENVIRONMENT
@ID uniqueidentifier
as
begin

  if @ID = 'ACC537E6-028D-4C72-9AC8-0E2BE19636AB'
    raiserror(N'Production environment cannot be deleted.',10,1)
  else
  begin
      delete dbo.BBPAYENVIRONMENTTEMPLATE
      where ENVIRONMENTID = @ID

      delete dbo.CRMBBENVIRONMENT
      where ID = @ID
  end

end