-
I've a problem, who can help me? I've a SQLServer table sorted by a type code field that show the following records A A2 A3 B B2 C Why the same table called like a temporary table, containing the same record and ordered with the same key, show records ordered like the following? A B C A2 A3 B2...
-
The given error can also occur when trying to change the property DatabasePerCompany to "No" by importing a fob or fbk SQL puts the Companyname in front of the tablename, that causes the problem. This can be solved by first changing the property DatabasePerCompany of the table50000 and then...
-
The Navision restore into SQL does a security sync at the end. The error you are getting is because you have a role configured that refers to Table 50000 and that table does not exist. To solve: 1. Go back to you native DB 2. Run the Permission table from object designer 3. Filter where "Object...
Posted to
Dynamics NAV / Navision - Microsoft SQL Server Forum
(Forum)
by
babrown
on
Nov 30, 2007
Filed under: Restore, SQL Server 2005 SP2, SQL Server 2005, NAV 4.0, SQL Server, NAV 4.0 SP3, SQL vs Native, NAV 4.0 SP2, Errors, ErrorsRestore
-
... another option to find the object with the problem is within the Object Designer, Select All objects and then compile them all (F11). This might take a while, but will find all compilation errors within all objects (the objects with errors will get "marked" - so select "Marked Only"...
-
Table ID 50000 is the first number available for customization. So somewhere in another table, report or codeunit there is a reference to this tableid. Obviously this table does not exist anymore. Check reports or codeunits starting with ID 50000 up to 99999, if there is areference to table 50000
-
dear friends i have to convert the navision 4.0 database to SQL DataBase (i have run max test in navision and took a back up in Navision) then i tried to restore the Navision DB to SQL Database(wich i have created using SQL sever option in Navision) then i am getting the following error massage. Table...
-
Hello, does any of you has the similar problem with me? we always have a synchronize user problem all the time... I have a test navision DB which use for training and testing.... when we insert a new user, sometime it goes ok..but sometime we need to delete and insert and syn for several time.... any...
-
We have 8 Citrix servers. 6 of these with 4.02 client with one of the later hotfixes. 4.03 client on the remaining 2 citrix servers because they are newer. It works. No issues so far, I know its not purist but I so far I have no reason to doubt mixing 4.02 & 4.03. I reckon I will schedul in the 5...
-
Can you mix clients like that OK? In any case, why not just put 5.00 executables now. If you are upgrading anyway, surely thats the best so you don't need to do it again later. if you are not ready to risk 5.00 then at least put 4.00 SP3 everywhere, and not just on some work stations.
-
Its what Microsoft advised me to do. Quite a long story and would be happy to discuss again. I have some other posts on this websitre from a while back relating to plan guides, also check http://www.mibuso.com/forum/viewtopic.php?t=16343&highlight=guide where it is also discussed. I am not a SQL...