You require a MrotatorTCPShort from www.agnos.com
Using the Canon 40D and Sigma 8mm Fisheye you will need to take 4 shots at 90 degrees (the camera will be in portrait mounting position). These will be stitched in "Drum" image type in Panoweaver 4.0 or 5.0 You may also elect to shoot an Up/Top/Zenith and Down/Bottom/Nadir shot. This will not exclude the tripod. For this to happen you would have to photograph that area hand held. Typically people clone or cap the tripod out of the view.