I need help getting a MS sql database schema and contents imported into my godaddy hosting account (4GH plan, SQL server 2008).
I have the database running locally okay using Microsoft SQL Server 2008 R2 Express. I am able to generate the import script, but seems there is a user and/or other permission error when I go to execute the import sql statement over on godaddy server (via tools > query analyzer).
Here is an example error message....
The specified schema name "dbo" either does not exist or you do not have permission to use it. CREATE SCHEMA failed due to previous errors.
If you know how to fix this, please respond.
Skills: ms sql, godaddy hosting