Limit to connections in sql express 05?

If I deploy a database to the web using sql express 05 is there a limit to the number of connections that can be made on it? I have read posts stating that but cant find any documentation from MSFT that supports that idea. I just know that it has a limit of a db size to 4 gigs.

Thanks!

SQL 2005 Express does not have a connection limit like MSDE did. 4 GB database and 1 GB RAM limits. It's in Books Online if you installed it.

Jeff

|||cool thanks Jeff.|||

jeff@.zina.com:

SQL 2005 Express does not have a connection limit like MSDE did. 4 GB database and 1 GB RAM limits. It's in Books Online if you installed it.

Jeff

|||

argh I hate not being able to edit! So if i deploy a website to the WWW built with VS Standard edition and a sql express db and it becomes wildly successful, will it be hard to upgrade the express db to a enterprise or standard db so that the website continues to function? I could just buy the license and then?...

Thanks.

|||

You can normally just attach the Express database in the new SQL. You may have to change a connection string, but even that may simply work for you.

Jeff