Can't see tables in SQL but in NAV

CaponeCapone Member Posts: 125
edited 2011-06-29 in SQL General
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. :-k
Hello IT, have you tried to turn it off and on?
Have you checked the cables?
Have you released the filters?

http://www.navfreak.com

Answers

  • CaponeCapone Member Posts: 125
    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..
    Hello IT, have you tried to turn it off and on?
    Have you checked the cables?
    Have you released the filters?

    http://www.navfreak.com
Sign In or Register to comment.