the faulty {databaseOwner}sysObjects can be found in the following files:

• 03.03.00.SqlDataProvider
• 03.03.02.SqlDataProvider
• 03.03.04.SqlDataProvider

The "Parameter count does not match Parameter Value count" error is caused by a change in the sprocs that is not applied if you db user does not have DBO rights. This seems to be a common practice in shared hosting environments

Maybe a quicker fix would be this (run all scripts from host>sql)

 drop procedure {databaseOwner}{objectQualifier}GetAnnouncements

next run this script:

CREATE procedure {databaseOwner}{objectQualifier}GetAnnouncements

@ModuleId int,
@StartDate datetime,
@EndDate datetime

as

select {objectQualifier}Announcements.ItemId,
       {objectQualifier}Announcements.ModuleId,
       {objectQualifier}Announcements.CreatedByUser,
       {objectQualifier}Announcements.CreatedDate,
       {objectQualifier}Announcements.Title,
       {objectQualifier}Announcements.URL,
       {objectQualifier}Announcements.Description,
       {objectQualifier}Announcements.ViewOrder,
       {objectQualifier}Announcements.PublishDate,
       {objectQualifier}UrlTracking.TrackClicks,
       {objectQualifier}UrlTracking.NewWindow
from   {objectQualifier}Announcements
left outer join {objectQualifier}UrlTracking on {objectQualifier}Announcements.URL = {objectQualifier}UrlTracking.Url and {objectQualifier}UrlTracking.ModuleId = @ModuleID
where  {objectQualifier}Announcements.ModuleId = @ModuleId
and    ( (({objectQualifier}Announcements.PublishDate >= @StartDate) or @StartDate is null) and (({objectQualifier}Announcements.PublishDate <= @EndDate) or @EndDate is null) )
order by {objectQualifier}Announcements.ViewOrder asc, {objectQualifier}Announcements.PublishDate desc

These two scripts will fix the GetAnnouncements sproc on your dnn instance.

The next version of announcements just entered the module release process, i hope it will be cleared for release soon.....

cheers,

Erik