Hello,

Could you be more precise, because if I follow the first method written here (i.e. deleting the tables), the install does not work for me.
So, I assume your solution will work for me. Could you please add few details, so I can do it myself (I am a newby, please try to be as specific as possible, I have few knowledge en SQL and accessing my tables). Do I need to:
1- Install the help module before creating the procedure ?
2- Then creating the procedure you describe (please indicate the sql to create it)
3- Re-installing it or not ?

Here is the error message I have:

StartJob Start Sql execution: 02.00.02.SqlDataProvider file
Failure SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException: Incorrect syntax near '@Search'. 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) /************************************************************/ /***** SQLDataProvider *****/ /***** Help *****/ /***** *****/ /***** Note: To manually execute this script you must *****/ /***** perform a search and replace operation *****/ /***** for dbo. and *****/ /***** *****/ /************************************************************/ /* Insert here the code to create tables and stored procs */ CREATE PROCEDURE dbo.[Help_SearchTutorials] @Search nvarchar(100) AS SELECT dbo.Help_Tutorials.TutorialGUID, dbo.Help_Tutorials.TutorialID, dbo.Help_Tutorials.Title, dbo.Help_Tutorials.ProductImage, dbo.Help_Tutorials.Featured, dbo.Help_Tutorials.KeyWords, dbo.Help_Tutorials.DownloadName, dbo.Help_Tutorials.ShortDesc, dbo.Help_Tutorials.Archive, dbo.Help_Tutorials.Description, 0 AS ViewOrder FROM dbo.Help_Tutorials WHERE (dbo.Help_Tutorials.Title LIKE N'%' @Search '%') OR (dbo.Help_Tutorials.KeyWords LIKE N'%' @Search '%') OR (dbo.Help_Tutorials.ShortDesc LIKE N'%' @Search '%') OR (dbo.Help_Tutorials.Description LIKE N'%' @Search '%') 
EndJob End Sql execution: 02.00.02.SqlDataProvider file

Many Thanks.
Déclic Vidéo

Yes, I have direct access, I have ran it again, I have verified, and ALL tables AND procedures have been deleted.
But as soon as I try to install the help module again, I have the error message listed above...
That's why I asked yairt to be more precise concerning his method. I am sure it will help me, but I need additionnal help. If you look at the end of my error message, it looks like that method suggested by yairt:

==============================
{...}
CREATE PROCEDURE dbo.[Help_SearchTutorials] @Search nvarchar(100) AS SELECT dbo.Help_Tutorials.TutorialGUID, dbo.Help_Tutorials.TutorialID, dbo.Help_Tutorials.Title, dbo.Help_Tutorials.ProductImage, dbo.Help_Tutorials.Featured, dbo.Help_Tutorials.KeyWords, dbo.Help_Tutorials.DownloadName, dbo.Help_Tutorials.ShortDesc, dbo.Help_Tutorials.Archive, dbo.Help_Tutorials.Description, 0 AS ViewOrder FROM dbo.Help_Tutorials WHERE (dbo.Help_Tutorials.Title LIKE N'%' @Search '%') OR (dbo.Help_Tutorials.KeyWords LIKE N'%' @Search '%') OR (dbo.Help_Tutorials.ShortDesc LIKE N'%' @Search '%') OR (dbo.Help_Tutorials.Description LIKE N'%' @Search '%') 
{...}
==============================

If anyone has an idea how to do this ?? (especially which instruction to put to create this procedure...)

Déclic Vidéo FX