Hi experts,
The problem is that an accident occurred while I deleting a company in NAV. So this makes that company is not exist in NAV but still available on SQL Server. I tried to select that company Company table (2000000006) via SQL query but there is nothing.
How can I drop all tables in that company with C/AL?
NOTE: I have an idea about this solution by writhing SQL query to recursive drop all tables in the company but I worry about the impact from the query (skipping NAV Code). Can anyone suggest me how to fix this problem with C/AL?
Thanks,
0
Answers
Try refreshing SQL OR Start SQL Services.
Blog - rockwithnav.wordpress.com/
Twitter - https://twitter.com/RockwithNav
Facebook - https://facebook.com/rockwithnav/
The system was freeze and terminated while changing company name. After that the old company not exists in NAV but still available on SQL database.