mibuso.com

Greetings!

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.

Solved!

The tables were single instance which means that they start with dbo.<TableName> and not <Company Name>$<TableName>.

The reason the vendor can't access the tables is another problem..