Database Configuration method of hichina Space

Recently, I used the M host-m3 and. Net platforms of the 10 thousand network. Some errors occurred while configuring the database, which were recorded for reference.

 

Sql2005 is used for local development, and SQL2000 is provided by the Space Provider. Therefore, a conversion is required. Use 2005 to generate a script. Select the "SQL2000" platform when generating the script, and connect to the database of the Space Provider with the manager for query. the following error occurs:

 

 

The search result shows that hichina does not Assign db_owner permission to the current database user, and all the places including DBO In the result statement are incorrect, prompting you to have no permission.

 

Modification Method: replace all the DBO statements with the allocated database user, and then query the database.

 

Then, use the Import and Export function to export 2005 of data to 2000. Because SQL2000 does not support some features of 2005, such as architecture, these features cannot be used during development.