0

On an attempt to import an SQL into a Database I get this error.

* Error 0xc002f210: Preparation SQL Task 1: Executing the query "IF NOT EXISTS(SELECT * FROM sys.schemas WHERE name..." failed with the following error: "CREATE TABLE permission denied in database 'WebsiteDatabase'.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.
 (SQL Server Import and Export Wizard)
1

That error is fairly straightforward, the Import Wizard is checking if the destination table exists and trying to create it because it is missing, but your login doesn't have sufficient permissions on the database or server to create a table.

I'm assuming you're not a DBA based on the question, so you're probably best placed to have your DBA look at either creating the table for you, running the import for you or granting you the required permissions.

Not the answer you're looking for? Browse other questions tagged or ask your own question.