Building with SQL server, but deploying with MSDE

I am building a site, I'd like to use SQL server, but once the site is finished it i for a organisation who do a lot of community voluntary work. So to keep the costs down I plan to install on their server a copy of MSDE as the datasource.

I know it is a simple question, but if I build the site using SQL server and deploy onto MSDE will the site still work?::I know it is a simple question, but if I build the site using SQL server and deploy onto MSDE
::will the site still work?

This depends on what you do in SqlServer.

Using Sql Server: works.
Using Full Text Search extension: No luck.

And any additional service - out of luck, too.

But if you just use what MSDE can deliber (core SQL), then - yes, it will still work.

Building a community

Hi!

Hello. I have now started to build my own community. And I have some questions on the database.

For the users to login I use the login control and all the users information is stored in the ASPNETDB.MDF database.
In the web.config file I have created some profiles for saving some information about the users (Name, Birth, Town) and so on.

Now. All the users in this community will have their own profile page, Guestbooks ++.

So I was wondering if I should create tables for all features like guestbook, profile pages or should I do this by using Profile (ASP.NET).

How many users does ASPNETDB support?.

I suppose it depends on which server are you running it, Mostly it is limited to database size and is limited to

4 GB maximum database size on SQL Express but no limit in paid versions.

And it probably depends on your system speed to prevent user to wait couple of minutes to login.

And you can always create separate user database for each of your web page if 4GB is too small for you.

Thanks