-
Well I'm really new to this and today I install my first instance of Navision 4 SP2, SQL 2005 on a Windows 2000 server (fully patched). The client runs with no problems on the server, but when I installed the client on a Citrix server (Version 1.8), the client fails to find the database server. The...
-
Hi, We are new to GP and just evaluating it. We installed SQL 2005 and then GP 10 on a laptop. When trying to go to Utilities, it gives 'sa' as the user and prompts for the password. Help says it is the DYNSA password. Which one is that? Thanks, Ed
-
Hi all, I'm using navision 5 sp1 over sql server 2005 , I've some problems to assign a specific menu to domain\usergroups . As before with the single user, I'm trying to using "navigation pane desgin" and "assing user" to allow my domain\usergroups to see a specific menu...
-
Hello, In order to update Nav 3.6 sql option to Nav 5.0, my customer technician install the sql 2005 on the server on which are installed the old database(sql server 2000). he doesn't make a parallel installation but a upgrade. he doesn't make the backup of old database before. Now the old database...
-
We are considering moving a few of our local Navision installations currently running Navsion 3.60 / 3.70 into our centrally hosted environment. Our central environment is using Microsoft SQL Server 2005. Of course we could "just" upgrade the client to NAV 4.0 or NAV 5.0, but we really would...
-
Don't get me wrong, learning how to write SP's is a good skill to have, and you will certainly not waste your time Just realize that you're not hitting any essential NAV business logic when working directly on SQL Server. Not just manipulating data but also retrieving data. Inventory valuation...
-
[quote user="DenSter"] If you are going to learn something new, learn how to do these things directly in NAV [/quote] Thanks for your reply. Since I don't want to mess up business by making an first SP, I'll stick to my plan and place the SP in the reporting database. Haven't had...
-
[quote user="DenSter"]You shouldn't use T-SQL as your go-to tool to manipulate data in NAV[/quote] Daniel: you (as always ) are completely right, but in this case its about REPORTING only... Bas even created his View in a different database not to mess up NAV. Even though I use SP`s regularily...
-
Standard NAV database do not have stored procedures. You shouldn't use T-SQL as your go-to tool to manipulate data in NAV, because that way you will miss a all the business logic that is part of NAV. If you are going to learn something new, learn how to do these things directly in NAV
-
Hi Modris, My knowledge of stored procedures is that I know they exist (in SQL). But every day is a good day to write a first stored procedure. I'll start by browsing the Dynamics database for SP's because there might just be a clue somewhere in there. And of course the internet. If I don't...