Most of the people (including me) use visual web developer express edition and have installed SQL server express editiion without SQL server management studio.

As per the set up instructions of BlogEngine.net 1.6 , set up SQL script for SQL server can be run in SQL server management studio.

Although, SQL server management studio can also be downloaded from microsoft site, but what should be done if you dont want to install it?

Here are the steps to install BlogEngine.net 1.6 schema using only Visual Web Developer Express Edition.

1) Download the following modified version of the MS SQL server install script.

MSSQLSetup1.6.0.0_Modified.txt (31.04 kb)

2) Open your Visual web developer and go to databse explorer. (Assuming that you have already created the database.mdf file)

3) Right click on 'Tables' and click 'New Query'.

4) A new dialog box 'Add table' will open up for query writing. Click 'Close'. We dont need to use it.

5) In the SQL view of the query window, just copy paste the contents of the above file.

6) Click the red colored exclamation mark to run the query.

7) An error may be thrown for some syntax error or operation not allowed. But just ignore the error.

8) Give it some time and your database schema should be installed. Just refresh the tables folder and you will see the newly created tables with data.