Just to let you know I've experienced the spatial join bug found in SP4.
I was joining 740000+ points to 13 polygons Just under 19000 records had attribute data come across. The rest were all null.
I've run the exact same data on another machine with ArcGIS 10 SP3 and it worked fine.
I see there was a bug listed ( NIM079126 ) but for some reason it's been declined. Not sure why this is, but you should know this is happening to others.
One thing I noticed was the last record to have an entry before the attributes failed to populate was a point that was outside all polygons I was trying to join to. I'd suggest creating a point dataset with one point outisde the main body of a join polygon to test this. Maybe then we can see some work towards a solution.
I too have struck this bug, and unfortunately using "Keep All Target Features" doesn't work for me as I still need the points to be present, even if they don't spatially join. I am now attempting to uninstall SP4 just so I can run my model.
I wanted to let you know that this toolbox did the trick. I was also having the same problem with points that did not intersect with a polygon would not transfer their attributes.
The attached Toolbox contains a model that may be helpful in working around this issue until the bug is resolved. It has proved helpful for some customers.
