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

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!