You might want to run check/synchronize ( with index checked ) on all the modules?. Normally if you have data that does not match to that of indexes we run in this kind of issues.
or did you move any code recently ( app ) as sometimes if the ax tables are 'in use' by some other tools ( such as DW real time replciation ) , we will also get this kind of issues. kind regards, subbu --- In Axapta-Knowledge-Village@yahoogroups.com, Varden Morris <[EMAIL PROTECTED]> wrote: > > If you can afford to lose the data in the table, or do a backup of the data, you can try dropping the table from the SQL database and then re-sync it in DAX. > > Regards, > > Varden Morris > > MCDBA, MCT > 276 Taralake Terrace N.E. > Calgary, Alberta T3J 0A1 > Canada > > (403) 366-8434 (H) > (403) 615-1604 (C) > [EMAIL PROTECTED] > > > > > > > ________________________________ > From: rajpaltn <[EMAIL PROTECTED]> > To: Axapta-Knowledge-Village@yahoogroups.com > Sent: Friday, November 14, 2008 3:35:24 AM > Subject: [Axapta-Knowledge-Village] SQL sync error > > > Dear All, > When i am synchonising the data dictionary, im getting the error > 1)"Cannot execute the data definition language command on ().The SQL > database has issued an error". > 2)I have tried to synchronise the tables from SQL Administration -- > >Synchonise > 3)It says Syncronisation Failed on 1507 tables. > 4)I have checked the event viewer and there are errors relating to > evevry > table sayin the object already exists and the error id is 117. > I wld appreciate any help >