According to Microsoft, 255.
According to the real world, it depends on a number of factors, but the
practical limit I have seen maxes out at about 20. Others have seen 50 or
more.
Depends on if the database is split, indexed, properly designed for multiple
users, etc.