Working with DNN 3.1.1 and setting up a updated data server configured in SQL2005 from 2000. The data file was created from a back-up of the original file on the DNN configured server to another server. We have a problem now with DNN not showing any of the Text/Html files and giving the error of  Text/HTML is currently unavailable.  The other files are there (pictures etc.). Also in the Admin mode no text editing or creating of a new Text/HTML page is available, with the same error appearing.  All the files seem to be present on the new database server which we are using seperate from the DNN server.  In the Host mode this message is present:

Error: Text/HTML is currently unavailable.
DotNetNuke.Services.Exceptions.ModuleLoadException: The stored procedure 'dbo.GetHtmlText' doesn't exist. ---> System.InvalidOperationException: The stored procedure 'dbo.GetHtmlText' doesn't exist. at System.Data.SqlClient.SqlCommand.DeriveParameters() at System.Data.SqlClient.SqlCommandBuilder.DeriveParameters(SqlCommand command) at Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.DiscoverSpParameterSet(SqlConnection connection, String spName, Boolean includeReturnValueParameter, Object[] parameterValues) at Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.GetSpParameterSetInternal(SqlConnection connection, String spName, Boolean includeReturnValueParameter) at Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.GetSpParameterSet(String connectionString, String spName, Boolean includeReturnValueParameter) at Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.GetSpParameterSet(String connectionString, String spName) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(String connectionString, String spName, Object[] parameterValues) at DotNetNuke.Modules.Html.SqlDataProvider.GetHtmlText(Int32 moduleId) at DotNetNuke.Modules.Html.HtmlTextController.GetHtmlText(Int32 moduleId) at DotNetNuke.Modules.Html.HtmlModule.Page_Load(Object sender, EventArgs e) --- End of inner exception stack trace ---

Has anyone experience this before and can supply any answers?