I am upgrading from 4.9.5 to 5.2.x.  Following the DNN Upgrade Path guide suggested by Will.

Each time I upgrade I am seeing the following errors in my logs:

System.Data.SqlClient.SqlException: Incorrect syntax near the keyword 'to'.
Cannot find the object 'SearchAllTables', because it does not exist or you do not have permission.
Cannot find the object 'SearchAllTables', because it does not exist or you do not have permission.
Cannot find the object 'NTForums_GetForumsByGroup2', because it does not exist or you do not have permission.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(SqlConnection connection, CommandType commandType, String commandText, SqlParameter[] commandParameters)
   at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters)
   at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText)
   at DotNetNuke.Data.SqlDataProvider.GrantStoredProceduresPermission(String Permission, String LoginOrRole)

if exists (select * from dbo.sysusers where name='DNN')  begin    declare @exec nvarchar(2000)     declare @name varchar(150)     declare sp_cursor cursor for select o.name as name     from dbo.sysobjects o     where ( OBJECTPROPERTY(o.id, N'IsProcedure') = 1 or OBJECTPROPERTY(o.id, N'IsExtendedProc') = 1 or OBJECTPROPERTY(o.id, N'IsReplProc') = 1 )     and OBJECTPROPERTY(o.id, N'IsMSShipped') = 0     and o.name not like N'#%%'     and (left(o.name,len('')) = '' or left(o.name,7) = 'aspnet_')     open sp_cursor     fetch sp_cursor into @name     while @@fetch_status >= 0       begin        select @exec = 'grant EXECUTE on ' +  @name  + ' to [DNN]'        execute (@exec)        fetch sp_cursor into @name       end     deallocate sp_cursor  end
 

I did some looking around about SearchAllTables and I am seeing that perhaps at some point it got injected into the database.  However at this point I am having problems finding it and getting rid of these errors.  Any help or insight would be appreciated.

Thanks,
Stuart

 This might help...

http://www.activemodules.com/Communit...

If it doesn't, you need to connect to the database using sa or other admin account to find the objects.  The objects are definitely in the database.

DotNetNuke version 05.02.02 was released today and fixes the GRANT EXECUTE TO issue. Give that a try!