You can absolutely use SQL Server Express.  In fact, many of our smaller medical installations use SQL Server Express until they outstrip it and then we just upgrade them to a Standard version.  Do not be afraid to use SQL Server Express in a production environment.  It is a great database and has been vastly improved from MSDE!

I have a new project that is very small, are there any reasons why I can't have SQL Express be the production database if I am ok with the 4GB database size and the fact that I will have to script backups.



Thanks.

Keith Chisarik