dear author:

 thank you for your great work, there is sqlserver 2005 in my XP System, so i install thebeerhouse with sqlserver2000, after runing aspnet_regsql.exe,All went well, I got all the relevant tables into my database ,but when i run CreateAllObjects (sql script file in App_Data folder), i meet with many many errors such as:

 CREATE ROLE [aspnet_WebEvent_FullAccess] GO This is the error: Server: Msg 170, Level 15, State 1, Line 2 etc;

why? please tell me the solution in detail thank you !!!!

Not much detail to specify: it requires SQL 2005, in any of its editions (and it even works on the free Express edition). If you want to run it on SQL 2000 you have to port the SQL and tables as needed. Porting of this nature is not covered in the book.

I think some readers have ported their TBH site to work on SQL 2000, but I haven't seen any of them post their code to share with others. It's more work than I care to do, unless I were being paid for my efforts, of course!

Eric

thank you for your reply ,but no answer really!

Here's just a suggestion...try building the site for SQL 2005, make sure it works, then use Microsoft's Database Publishing Wizard to create a script from it, that you then run on your SQL2000 database.

But some of the SQL code won't load on 2000, and the SQL embedded in the application also assumes 2000. I honestly can't understand how people want to use a 7 year old DBMS in today's world. You certainly won't impress anyone with your CV/Resume. Even VS 2003 is 3 years newer than SQL 2000.

Someone did post some results on his conversion from SQL 2005 to 2000. Maybe you could search in this forum for more info.

Eric