When i am trying to do something in Ax,am getting the error as "Can’t select a record in vendor account.The SQL database has issued an error".So i compiled and synchronized the VendTable and got another error as
“can’t excecute a data defination language command on().The SQL database has issued as error.”
Eventvwr is showing as “There is already an object called ‘VendTable’ in database.”
So i deleted the dbo.VendTable in SQL and again synchronized VendTable in AX.
Now dbo.VendTable got created in SQL but still the problem is same.