You can use the Sigma 8mm Fisheye but you will need to shoot 3 images 1 every 120 degrees.
Even using the 183 degree images from a Nikon Coolpix with FC-E8 or FC-E9 I would suggest the exact same shooting sequence of 1 every 120 degrees meaning 3 shots to create a full 360x180 equirectangular panoramic image.
Off the shelf you have the Sigma 8mm Fisheye and Peleng 8mm to choose from only for the D700.
All other options for "minimal" shooting require modifying a APS-C/DX small sensor lens by removing the sunshade such as the Tokina 10-17mm Zoom Fisheye or Nikkor 10.5mm Fisheye or the Samyang 8mm Fisheye. All of these would also allow you to shoot a minimum of 3 shots to cover the full 360x180 "after" modification.
Explain what you want from your equipment and what you want to produce and I will happily advise the way I would go.