The Super Proton Synchrotron (SPS) will serve as an injector to the Large Hadron Collider (LHC) at CERN as well as it is used to accelerate and extract proton beams for fixed target experiments. In either case, safety of operation is a very important issue that needs to be carefully addressed. This paper presents detailed numerical simulations of the thermodynamic and hydrodynamic response of solid targets made of copper and tungsten that experience impact of a full SPS beam comprized of 288 bunches of 450 GeV/c protons. These simulations have shown that the material will be seriously damaged if such an accident happens. An interesting outcome of this work is that the SPS can be used to carry out dedicated experiments to study High Energy Density (HED) states in matter.