StartJob

Start Sql execution: 02.00.02.SqlDataProvider file

Failure

SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException: Line 31: Incorrect syntax near '@Search'. 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