I get an error while trying to copy data from one table to another,
10 The EXECUTE permission was denied on the object 'xp_create_subdir', database 'mssqlsystemresource', schema 'sys'. DataSynchronization1.sql 24 1
Any ideas?
Error copying data
dbForge executes 'xp_create_subdir' procedure when a user wants to backup his/her database before synchronization. This procedure creates a path to your future database backup if it was not created yet. You don't have permissions to create a directory on your SQL Server, that's why you have got an error.
There are many ways to bypass this error:
1. Delete this string from your generated synchronization script if you are sure the backup directory exists.
or
2. Uncheck the "Backup the target database" option (Synchronization wizard -> Options page) if it is not necessary for you to backup your database before synchronization (For example: you have backed it up before).
or
3. Contact your system administrator and get the EXECUTE permission for the object 'xp_create_subdir'.
There are many ways to bypass this error:
1. Delete this string from your generated synchronization script if you are sure the backup directory exists.
or
2. Uncheck the "Backup the target database" option (Synchronization wizard -> Options page) if it is not necessary for you to backup your database before synchronization (For example: you have backed it up before).
or
3. Contact your system administrator and get the EXECUTE permission for the object 'xp_create_subdir'.