Hi guys,

I am trying to develop a new module and I am getting error when I have to run the script included on 01.00.00.SqlDataProvider. I logged in the website, I went to Host > SQL. Paste the script and check the "Run as script"  box. I get the error.
System.Data.SqlClient.SqlException: Line 16: Incorrect syntax near '.'. 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) /** Create Stored Procedures **/ create procedure dbo.YourCompany_GetMyDocumentss @ModuleId int as select ModuleId, ItemId, Content, CreatedByUser, $YourCompany$_$safeprojectname$.CreatedDate from YourCompany_MyDocuments with (nolock) left outer join Users on YourCompany_MyDocuments.CreatedByUser = Users.UserId where ModuleId = @ModuleId System.Data.SqlClient.SqlException: Line 14: Incorrect syntax near '.'. 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) create procedure dbo.YourCompany_GetMyDocuments @ModuleId int, @ItemId int as select ModuleId, ItemId, Content, CreatedByUser, $YourCompany$_$safeprojectname$.CreatedDate from YourCompany_MyDocuments with (nolock) left outer join Users on YourCompany_MyDocuments.CreatedByUser = Users.UserId where ModuleId = @ModuleId and ItemId = @ItemId