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
