cobby1 wrote:Yes it does fit on the hot shoe
Want to get it to one side for some macro shots hand held
What Pa said; care needs to be taken in attempting this
The SB800 is a reasonably powerful unit, and for macro work, you're going to need to control the power and direction of the light.
In using it on a bracket off to the the side of the camera, you're running the risk of getting shadows from the camera as it stands in the way of the subject from the flash. You will find that the flash needs to be moved forwards and closer to the subject, making the light even more overpowering relative to your subject.
If you place it too far to the side, you may end up with too strong side-lighting of the subject.
Consider, with it mounted in the hotshoe, turning the head of the SB800 to one side and then bouncing it off some white paper or card: this will have the effect of changing the direction of the light source, plus diffusing it, plus reducing the power.
There are some simple brackets that you can buy at camera stores - Hama I think make some - and it's probably pretty easy to fabricate one yourself.
Or you can just hold the unit with one hand, for better and more flexible placement.
If you happened to get a free tripod in a kit when you bought your camera, as some stores do, this would be an ideal use for such a tripod - they're certainly unsuitable for putting any sort of a camera on.