Is there a connection limitation if using sql express? Also, is sql express recommended for use with an application that is sending about 60 or so transactions per minute over 18 or 20 connections from about 7am to 8 pm daily?
A vendor is considering trying to run this type of software on an MSDE database but I thought maybe sql express would work better but not even sure if that is the route they should go. Currently they are using our sql 2000 standard edition but all their connections(avg of 25)will just drop from sql, so now they want to consider installing an MSDE version on the application server.
Juanita