that is correct.  Just press update under the settings for the module.

Also there is a mistake in teh SQL run this as well

Run this script.  Thre was a dyslexic mistake I had the Parent and moduleid around the wrong way.

ALTER PROCEDURE {databaseOwner}[{objectQualifier}Help_ListCategoryActiveByParent]

@ParentID int,
@ModuleID int
 
AS
SELECT   [CategoryID],
   [CategoryGUID],
   [Name],
   [Description],
   [Image],
   [KeyWords],
   [ModuleID],
   [Order],
   [Level],
   [Parent],
   [Visible],
   [Deleted]

FROM   {databaseOwner}{objectQualifier}Help_Category

WHERE  [Parent] = @ParentID AND [ModuleID] = @ModuleID
AND   [Deleted] <> 1
AND   [Visible] <> 0

ORDER BY [Level] ASC,
   [Parent] ASC,
   [Order] ASC
   
GO

Perhaps I followed your advice a too blindly, but I got the following error when I ran that script.

System.Data.SqlClient.SqlException: Incorrect syntax near 'GO'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.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 DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) ALTER PROCEDURE dbo.[Help_ListCategoryActiveByParent] @ParentID int, @ModuleID int AS SELECT [CategoryID], [CategoryGUID], [Name], [Description], [Image], [KeyWords], [ModuleID], [Order], [Level], [Parent], [Visible], [Deleted] FROM dbo.Help_Category WHERE [Parent] = @ParentID AND [ModuleID] = @ModuleID AND [Deleted] <> 1 AND [Visible] <> 0 ORDER BY [Level] ASC, [Parent] ASC, [Order] ASC GO

What do I need to do to fix this?