Visual Web Developers using SQL Server Express


I am planning on developing a small to medium size e-commerce web site for a customer. I will be using visual web developer to deploy the application. Is this possible? If not, are there any pluggins that would let me deploy (.dll and .exe) and package the application? Also I am using Sql Server express edition. I understand that it is free for redistribution as long as one registers the copy. I would like to now if there are any limitations for what I am trying to do using visual web developer and Sql Server express Ed. I think that Sql Server express is enough for what I am doing and it should not be to bad to upgrade as the business grow.

How many processors and memory bandwidth would Sql Server Express support? Are dual core processors considered one cpu or two cpu's? Any inputs or thoughts will be greatly appreciated. Thanks.
Who is Participating?
surajgupthaConnect With a Mentor Commented:
If SQL Server 2005 Express is running on Windows XP Home, it is limited to five simultaneous connections. If it is running on Windows 2000 or Windows XP Professional, it is limited to 10 simultaneous connections. However, these are limitations of the operating system and not of SQL Server 2005 Express.

About multi core support of SQL server express. More details are available here

You might want to check the scalability and performance section on this link

Also check out the common issues section for more details about SQL server limitations

You should be able to deploy the web application with Visual Web Developper with ease. As far as i know there are no limitations you might have deploying web apps using the web edition.
vielkacarolina1239Author Commented:
Thanks for the links.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.