I was looking at the issue travking and have seen a couple of related incidents and efforts to clean them up. (posted at end)
Well, if you think the upgrade to 4.0.2 will clean the old procs...then I'll try the upgrade. ....And 99% seems pretty good to me!
From EVT-3895 it follows that there may be other obsolete procs in there, but let's see about these first and see what happens. Will let you know.
Thanks.
EVT-3895
http://support.dotnetnuke.com/issue/ViewIssue.aspx?id=3895&PROJID=11
Upon a clean 3.3.x build, there are seven stored procedures which appear to be obsolete. Each stored procedure is referencing one or more columns that no longer exist in their respective tables. This was discovered while troubleshooting a database backup and restore script.
The stored procedures are as follows:
AddEvent
DeleteEvent
GetEvent
GetEvents
GetEventsByDate
UpdateEvent
Forum_ForumUserViewsUpdate
Although the presence of these procedures doesn't appear to affect 3.3.x functionality, it does cause issues when attempting to run auto-generated SQL scripts to rebuild the database.
Shawn Gerlock
Gerlock Internet Solutions LLC
EVT-7738
Speaks of unused sprocs, but doesn’t name them.
Roger Selwyn [6/2/2008 2:24:06 PM]
Complete by Fuji and Roger
18 SPROCs updated, 6 unused SPROCs dropped