Originally Posted by boma0021
MSDE is an "small" SQL Server you need an SQL Database since Version 4
you can run your db on either MSDE or SQL server in versions 3.6 onwards...
As to which is the most suitable to use then it depends on a number of criteria like
Number of users - the greater the number the more the number of users...
Need for "semi-automatic" failover
Need for flexibility
Do you have a SQL server instance (and skills) currently otherwise $1.5K for the license (guessing based on uk pricing)
I've re-read your post and you talk about 400 users. Personally I'd be going down the SQL server route with that number of users.. I think you need to contact your vendor to see what paid for BB support options are available..as clearly you need some fact time with a tech pro to fully understand the options, costs and implications..