That's great. So all I need to do is run this ALTER PROC script and all the SPs should be updated (with the additional columns,etc.) completely.
Am I correct?
Yes, you're absolutely right, this DNN install it's using the attached database. I will read through the post you suggested and fix this as soon as I get to my office later tonight.
As far as the site accessing the database, I'm not sure because it is loading and I am able to log in without any problems. As a matter of fact, I checked out what you had mentioned earlier: I hovered over Admin and clicked SIte Settings and the page opened without any problems.
Strange? Go figure...
I'm checking the Event Viewer and besides the error that created this whole thread (HTML module) I am seeing quite a few Scheduler Event Failures and Exceptions. If you have any advise about these specific alerts, I'm all ears.
I'll be working on all this later this evening.
Thank you so much for all your patience and wonderful help.
Xavier

That error is an indication that the site cannot connect to the database. Have you modified the web.config connection strings as shown in Shawn's blogpost about the problem of connecting to an database mdf file after touching it with SSMS? The other possibility is that there was a problem reading portal settings following the script execution which might be caused by other sprocs which failed to upgrade and are now out of sync with the one you updated.

I'd offer more assistance but am on the road this week with only smart phone internet access.

---

Bill, WESNet Designs
Team Lead - DotNetNuke Gallery Module Project (Not Actively Being Developed)
Extensions Forge Projects . . .
Current: UserExport, ContentDeJour, ePrayer, DNN NewsTicker, By Invitation
Coming Soon: FRBO-For Rent By Owner