This is one of those typical scenarios when a colleague goes on vacation and all shit brakes loose
The customer has introduced a new EDI functionality and a third part vendor is writing directly to the SQL tables.
This has worked without any problems until I uploaded a new license.
Now the vendor and even I can't see/find the tables in the SQL server. We can see all Navision tables except those.
But these are shown without any problem in the Object Designer in Navision.
First I thought it was a security problem but when I became sysadmin and dBowner I still can't see/find the tables. I even tried to do a select without success.
Navision is 5.0
SQL version 10.0.2531.0.
Security Model is standard.
I now my colleague has done something that could cause this change when I uploaded a new license but I don't know what.