sql-server tsql linked-server share|improve this question asked Nov 27 '12 at Abs 13.1k68208356 Is there a reason for you to do the delete with an OPENQUERY? –Lamak Nov 27 '12 at The link is to a My SQL database. –Abs Nov 27 '12 at I managed to solve this problem since My SQL will seem confused to which rows to delete if the table isn't specified i.e. You can have all kinds of system conflicts, registry errors, and Active X errors. It scans and diagnoses, then repairs, your damaged PC with technology that not only fixes your Windows Operating System, but also reverses the damage already done with a full database of replacement files. 5 minutes) into your PC's Windows Operating System detects problems divided into 3 categories - Hardware, Security and Stability.
First make sure the is properly registered by doing the following steps on the LANDesk Core Server: 1. In the command prompt browse to \Program Files\Landesk\Management Suite3. Ensure it states the dll register succeeded Next run dbrepair to clean up unmodeled data and coredbutil to check the database structure. Additional Troubleshooting: If the error description contains a table other than Unmodeled data then it is possible there are metaattributes pointing to nonexistant columns.To add new records to a database you use an append query, and to delete whole records from a database you use a delete query.Note: You cannot run an update query in a Web browser.You use an update query when you have to update or change existing data in a set of records.You cannot use an update query to add new records to a database, or to delete entire records from a database.