N/APosted on - 01/11/2012
A link was created between MySQL and MSSQL wherein we can replicate the database from MySQL once (the first time) but subsequently receive this error message: Executed as user: NT AUTHORITYNETWORK SERVICE. An object, “access right” can already be found in the database.
Executing it gets this error: [SQLSTATE 42S01] (Error 2714). Can you tell me how we can let MSSQL to write over the existing tables? Thank you.
Executed as user: NT AUTHORITYNETWORK SERVICE
Some guides to help you resolve that problem are as follows:
First of all, you will need to verify that you are in the right database, and you can do that using the following command: SELECT DB_NAME(), and also make sure that you are checking sysobjects in the correct database.
If have tried the above and it did not help, you will need to try the following:
You will need to open the IBM DB2 Control Center, and then you will manually drop the appropriate database.
Once you have done that, you will need to restart the machine so as to release the database and also allow the DB2 DROP command to complete.
See if that helps.