BugNET

You don't have to change the script.  The 0.8.140 script handles converting all of the old 0.7 tables to version 0.8 with prefixes.  This works pretty well but occasionally because the lack of foreign keys on the old tables , there are problems with data that may cause some errors.  If you roll back and just try the upgrade normally what error do you get?

Just thought i'd throw my two cents in here.  I also struggled with getting the database scripts to complete properly, until i realized BugNET was attempting to use integrated authentication to access the database when i thought i had configured the app to use sql server authentication.  In my case, since my intent was to use sql server authentication and provide the userid/pwd in the connection string in web.config, I had given that sql server user the keys to the kingdom access-wise but no such permissions were given on the windows account running the app.  Bottom line: I'd double-check your connection string and be sure that, given your means of authentication defined in the connection string, that user has appropriate permissions in the database.