As I mentioned elsewhere, I'm in the process of migrating our SPS2001-based intranet to a Windows Sharepoint Services backend. I haven't posted forever because this has been one of those longstanding gigs that consumes and destroys all other nerd quests in its path.
The SPS2001 intranet system employs a middle data layer as a merged SQL-Web Storage System XML data file which the applications hit, so part of the migration was to rewrite those apps to pull document data from the Sharepoint Services SQL databases.
Added to that I thought it would be a good time to clean up directory and file names to remove as many unicode characters as possible and start fresh. What, these users think they're using Macs?? %26, %3B, %20...like zits in URLs ready to pop. Hate em. I went down this path whole hog when I saw that I couldn't drag-n-drop a folder with a “&“ in it into a WSS Document Library. So the in-house migration app I wrote (MS doesn't provide a migration tool from $PS2001 to WSS that I've seen. Surprise) strips out the most offensive unicode characters on my zit list.
Things are going great across the board. We're wiring the last 50 feet now into users' bedrooms, which is always the toughest, but we're sitting pretty. Not as pretty as Julie Andrews, but pretty all the same.