Sorry it took so long to get this posted.  This is a step by step aimed for people who aren't all that familiar with this.  This is geared to getting a default club site working on GoDaddy.  I can't say its definitive, but it worked for me 3 times in row from a scratch site.  I'm also assuming you've downloaded VWD, club.vsi and the clubadd and clubremove scripts.  It also assumes you'll be managing several different windows.

1. Create your site locally.  Include AT LEAST 1 local admin account.
2. Run site using CTRL-F5.
3. Log into your GoDaddy hosting account and open the control panel.
4. Click on ASP.Net runtime and select 2.0
5. Click Databases > SQL Server > Create New Database.
6. Select
   1. Check DSN (optional?)
   2. Enter UserName (this will become the database name NOT your hosting login)
   3. Enter Password (again, database password NOT hosting password)
   4. Check "Install Schema Features"
7. Click Continue > Create Database (it WILL take some time for the database to create itself, you can refresh by clicking the SQL button in the left menu)
8. Once setup finishes, Click Pencil icon under actions > print this page.
9. Click Computer icon under actions > record the SQL Connection (.NET) strings
10. Click Open Manager
11. Click Connection > Enter the Username and Password from 6 above.
12. Once connected, expand Tools menu > Click Query Analyzer
13. Cut & Paste all text from club-add.sql into the Query Analyzer window
14. Click Submit (you should see many "command(s) completed successfully" below)
15. Go back to VWD and edit default.aspx
16. Go to Edit > Find & Replace > Quick Replace
    1. Find dbo. (NOT Dbo. big difference)
    2. Replace with <blank> (nothing, nada, zip, zero)
    3. Look in: Current Document
17. Click Replace All (should be 12 or more) > Save default.aspx
18. Repeat steps 16 & 17 for:
    1. Events_Edit.aspx
    2. Events_View.aspx
19. Open web.config
    1. Replace original text

       1. <add name="ClubSiteDB" connectionString="Data Source=.\SQLExpress;

                Integrated Security=true;

                AttachDBFileName=|DataDirectory|Club.mdf;

                User Instance=True" providerName="System.Data.SqlClient"/>

    2. With new text

       1. <add name="ClubSiteDB" providerName="System.Data.SqlClient"

                connectionString="server=whsql-v04.prod.mesa1.secureserver.net;

                database=DB_12345;

                uid=myusername;

                pwd=mypassword"/>

          <remove name="LocalSqlServer"/>

          <add name="LocalSqlServer" providerName="System.Data.SqlClient"

                connectionString="server=whsql-v04.prod.mesa1.secureserver.net;

                database=DB_12345;

                uid=myusername;

                pwd=mypassword"/>

20. Change <customErrors mode="Off" /> (optional)

21. Save!!!

22. Run CTRL-F5 again.  (it will bring up a window with a server error, what you want is to look in the lower left corner of the VWD window for "Build Successful")

23. Click Website > Copy Web Site > Connect

24. Input your hosting username and password (NOT you database uid and pwd)

25. Highlight all files from the left side and click right arrow to transfer.

26. Go to your public website and create an account for each admin you created on your local database.  (make sure the usernames and passwords are the same!!!)

27. Log back into Query Analyzer

28. Input

    1. SELECT RoleId FROM aspnet_Roles WHERE RoleName="Administrators"

29. Copy bracketed response into a text document and include the brackets

30. Reset QA and Input

    1. SELECT UserId FROM aspnet_Users WHERE UserName="username"

31. Copy each bracketed response to your text document.

32. Reset QA again and Input

    1. INSERT INTO aspnet_UsersInRoles (RoleId, UserID) VALUES ('copied text from 29', 'copied text from 31')

33. Repeat 28-32 for each admin account.

34. Welcome to your club site on GoDaddy!