Just an FYI... If you are running Sage 100 (formerly MAS90/200) Premium (ie MAS200 SQL), the user code (the three character code) can't have a ""."" in it. This may or not be in the advice that we receive from Sage, but I thought you all would like to know.
One of our clients just upgrade to the SQL version, and one user was getting an error about maximum prefixes. The ""."" in the user code (which Sage 100 uses to create temporary tables) made the SQL statement wrong.
Thanks to my wager with @EricAnderson on this issue, I'm $1 richer now. :-)