Hi all, I'm having trouble creating a couple of stored procedures when installing a module package I created.  The module works fine on my developement box but I get the following errors when it installs elsewhere:

Failure

SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException: Line 6: Incorrect syntax near 'JobCodeDesc'. at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) CREATE PROCEDURE IRIS_User.DNN_spCSJobCodesGetAll @ModID int AS SET NOCOUNT ON SELECT JobCodesID,JobCode,ModuleID,JobCodeDesc, JobCode '-' JobCodeDesc AS JCwDesc FROM IRIS_User.DNN_T_CSJobCodes WHERE ModuleID=@ModID System.Data.SqlClient.SqlException: Line 10: Incorrect syntax near '@Modstr'. at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) CREATE PROCEDURE IRIS_User.DNN_spCSRequestGetAll @ModID int, @qSortBy varchar(20), @qOrderBy varchar(10) as declare @query varchar(2000) declare @ModStr varchar(50) select @ModStr=RTRIM(CONVERT(VarChar,@ModID)) set @query = 'SELECT JobID,JobCode,JobName,ProgramDept,ProjectContact,ApprovalList,TBICopy,TBICopyProvBy,TBICopyAttach,TBILogos,TBILogosProvBy,TBILogosAttach,TBIImages,TBIImagesProvBy,TBIImagesAttach,TBISpecs,TBISpecsProvBy,TBISpecsAttach,Description,QuoteRequired,InHouse,CopyDue,FirstComp,ToClient,Delivery,ToSeparator,Quantity,ShipTo,MiscNotes,DateOpened,PreviousArtist,Artist,RequestingUserID,JobStatus,JobNumber,ModuleID FROM IRIS_User.DNN_T_CSRequest WHERE IRIS_User.DNN_T_CSRequest.ModuleID=' @Modstr ' ORDER BY ' @qSortBy ' ' @qOrderBy execute (@query) System.Data.SqlClient.SqlException: Line 11: Incorrect syntax near '@Modstr'. at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) CREATE PROCEDURE IRIS_User.DNN_spCSRequestGetAll_byStatus @ModID int, @JobStatus varchar(5), @qSortBy varchar(20), @qOrderBy varchar(10) AS declare @query varchar(2000) declare @ModStr varchar(50) select @ModStr=RTRIM(CONVERT(VarChar,@ModID)) set @query = 'SELECT JobID,JobCode,JobName,ProgramDept,ProjectContact,ApprovalList,TBICopy,TBICopyProvBy,TBICopyAttach,TBILogos,TBILogosProvBy,TBILogosAttach,TBIImages,TBIImagesProvBy,TBIImagesAttach,TBISpecs,TBISpecsProvBy,TBISpecsAttach,Description,QuoteRequired,InHouse,CopyDue,FirstComp,ToClient,Delivery,ToSeparator,Quantity,ShipTo,MiscNotes,DateOpened,PreviousArtist,Artist,RequestingUserID,JobStatus,JobNumber,ModuleID FROM IRIS_User.DNN_T_CSRequest WHERE IRIS_User.DNN_T_CSRequest.ModuleID=' @Modstr ' AND IRIS_User.DNN_T_CSRequest.JobStatus=' @JobStatus ' ORDER BY ' @qSortBy ' ' @qOrderBy execute (@query) System.Data.SqlClient.SqlException: Line 16: Incorrect syntax near '@Modstr'. at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) CREATE PROCEDURE IRIS_User.DNN_spCSRequestGetAll_byStatusUser @ModID int, @JobStatus bit, @ReqUserID int, @qSortBy varchar(20), @qOrderBy varchar(10) AS declare @query varchar(2000) declare @ModStr varchar(50) declare @JobStr varchar (1) declare @UsrID as varchar(50) select @ModStr=RTRIM(CONVERT(VarChar,@ModID)) select @JobStr=RTrim(Convert(VarChar,@JobStatus)) select @UsrID=rtrim(convert(varchar,@ReqUserID)) set @query = 'SELECT JobID,JobCode,JobName,ProgramDept,ProjectContact,ApprovalList,TBICopy,TBICopyProvBy,TBICopyAttach,TBILogos,TBILogosProvBy,TBILogosAttach,TBIImages,TBIImagesProvBy,TBIImagesAttach,TBISpecs,TBISpecsProvBy,TBISpecsAttach,Description,QuoteRequired,InHouse,CopyDue,FirstComp,ToClient,Delivery,ToSeparator,Quantity,ShipTo,MiscNotes,DateOpened,PreviousArtist,Artist,RequestingUserID,JobStatus,JobNumber,ModuleID FROM IRIS_User.DNN_T_CSRequest WHERE IRIS_User.DNN_T_CSRequest.ModuleID=' @Modstr ' AND IRIS_User.DNN_T_CSRequest.JobStatus=' @JobStr ' AND IRIS_User.DNN_T_CSRequest.RequestingUserID=' @UsrID ' ORDER BY ' @qSortBy ' ' @qOrderBy execute (@query) System.Data.SqlClient.SqlException: Line 13: Incorrect syntax near '@Modstr'. at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) CREATE PROCEDURE IRIS_User.DNN_spCSRequestGetAll_byUser @ModID int, @ReqUserID int, @qSortBy varchar(20), @qOrderBy varchar(10) AS declare @query varchar(2000) declare @ModStr varchar(50) declare @UsrStr varchar (50) select @ModStr=RTRIM(CONVERT(VarChar,@ModID)) select @UsrStr=RTrim(Convert(VarChar,@ReqUserID)) set @query = 'SELECT JobID,JobCode,JobName,ProgramDept,ProjectContact,ApprovalList,TBICopy,TBICopyProvBy,TBICopyAttach,TBILogos,TBILogosProvBy,TBILogosAttach,TBIImages,TBIImagesProvBy,TBIImagesAttach,TBISpecs,TBISpecsProvBy,TBISpecsAttach,Description,QuoteRequired,InHouse,CopyDue,FirstComp,ToClient,Delivery,ToSeparator,Quantity,ShipTo,MiscNotes,DateOpened,PreviousArtist,Artist,RequestingUserID,JobStatus,JobNumber,ModuleID FROM IRIS_User.DNN_T_CSRequest WHERE IRIS_User.DNN_T_CSRequest.ModuleID=' @Modstr ' AND IRIS_User.DNN_T_CSRequest.RequestingUserID=' @UsrStr ' ORDER BY ' @qSortBy ' ' @qOrderBy execute (@query)

Here are the two SP's in the SQLDataProvider script:

CREATE PROCEDURE {databaseOwner}{objectQualifier}spCSJobCodesGetAll
  @ModID int
 AS
 SET NOCOUNT ON
 SELECT JobCodesID,JobCode,ModuleID,JobCodeDesc,  JobCode + '-' + JobCodeDesc AS JCwDesc FROM {databaseOwner}{objectQualifier}T_CSJobCodes WHERE ModuleID=@ModID <---Don't know why it is hyperlinking this line in my post???
GO

CREATE PROCEDURE {databaseOwner}{objectQualifier}spCSRequestGetAll
  @ModID int,
  @qSortBy varchar(20),
  @qOrderBy varchar(10)
as
 declare @query varchar(2000)
             declare @ModStr varchar(50)
             select @ModStr=RTRIM(CONVERT(VarChar,@ModID))
 set @query = 'SELECT JobID,JobCode,JobName,ProgramDept,ProjectContact,ApprovalList,TBICopy,TBICopyProvBy,TBICopyAttach,TBILogos,TBILogosProvBy,TBILogosAttach,TBIImages,TBIImagesProvBy,TBIImagesAttach,TBISpecs,TBISpecsProvBy,TBISpecsAttach,Description,QuoteRequired,InHouse,CopyDue,FirstComp,ToClient,Delivery,ToSeparator,Quantity,ShipTo,MiscNotes,DateOpened,PreviousArtist,Artist,RequestingUserID,JobStatus,JobNumber,ModuleID FROM {databaseOwner}{objectQualifier}T_CSRequest WHERE {databaseOwner}{objectQualifier}T_CSRequest.ModuleID=' + @Modstr + ' ORDER BY ' + @qSortBy + ' ' + @qOrderBy

execute (@query)
GO

I know that is a lot to look at but I'm hoping someone can point me in the right direction.  I think the issue has to do with the ' and + characters but I have other SP's that use them without an issue.

Thanks,
Steve

As mentioned above I would check the encoding of your saved script.  Most likely it is not liking the ' character.