YIKES !
Thats an
AF 80-200mm f2.8 D ED, the earlier single ring push-pull version, made from 1987 to 1997 (1992 introduced the "D" variant, which is pictured, recognizeable by only having two positions on the focus limiter; the earlier version has three).
Its possibly the best telephoto zoom done by anyone, praised for being very prime-like in its rendering.
Its certainly NOT AT ALL, EVER EVER "Macro". For starters, Nikon calls their macro lenses "micro". With Nikon, only the extremely rare lenses that cant focus to infinity are called "macro".
Yes it has a focus limiter. That doesnt make a lens a macro lens. My telephoto zoom has a focus limiter, too.
The current version of said optics, the AF 80-200mm f2.8 D, two ring with tripod, produced since 1997, is
still current production, 30 years alter. It has now survived THREE successor optics and might as well survive the current top telephoto zoom from Nikon, the AF-S 70-200mm f2.8 E FL VR.
Its however not great for sports. Like all lenses by Nikon that gets called "AF" instead of "AF-S", its driven by the motor in the camera, after all.
Speaking of the camera (rather than start a new thread), I'm torn between a used D3 and a used D700. Thoughts?
Two excellent cameras, you'll be very likely extremely happy with either. The D3 apparently is a bit better for ISOs beyond 6400, and has two card slots, and has the better viewfinder, and you can record soundclips as comments to your pictures (no video with either cam though) etc.