I moved my website to the hosting control panel (ASP.NET files and SQL 2005 database).
The hosting provider does not allow the SQL stored procedures with schema name 'dbo' (for example - the provider does not allow 'dbo.aspnet_CheckSchemaVersion'). So, all 'dbo' schema became 'myusername' ie 'myusername.aspnet_CheckSchemaVersion' in the SQL database. Now, when I open my website, I am getting the following error -
Could not find stored procedure 'dbo.aspnet_CheckSchemaVersion'.
What change should I make in my ASP.NET (C#) to make the website to look for 'myusername.aspnet_CheckSchemaVersion', instead of 'dbo.aspnet_CheckSchemaVersion'?
...
Go to the complete details ...