How can I delete a company that not exist in NAV but available in SQL Server?

wolfskinwolfskin Member Posts: 83
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?


Best Answer


Sign In or Register to comment.