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

wolfskin

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,

Remco_Reinking

Add the company again using SQL, then delete it from NAV

Remco_Reinking

Add the company again using SQL, then delete it from NAV

RockWithNAV

How is even that possible?
Try refreshing SQL OR Start SQL Services.

wolfskin

RockWithNAV wrote: »

How is even that possible?
Try refreshing SQL OR Start SQL Services.

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.