-
V5.0 Beta on SQL Server
Does anybody know what trace flag 4616 is? Apparently you need to set this on your sql server before you can run V5 on it. Paul
-
All I want for Christmas is a real "SELECT" statem
Currently when we use a FINDFIRST, FINDLAST, FINDSET, FIND(‘+’), or FIND(‘-‘) NAV does a “SELECT *” or select all from the table even though we do not need all the columns. This means even though we may have an index that satisfies the WHERE and ORDER BY clauses it still has to look at the clustered index to pull the…
-
SQL Select Statement
Hello I need to write a sql select statement to find inventory value and Received Not Invoiced Value. It looks like Navision uses in report 10138. Inventory to G/L Reconcile report uses Value Entry table. I tried to sum up the Cost amount (Actual), Cost Amount (Expected), but I still cannot come up to the value on that…
-
Manage Startup Parameters in SQL Server 2005
Okay so I spent a long time figuring this out... In the SQL Server 2000 Enterprise Manager the startup parameters are right on the server properties, so it was frustrating to try and figure out where it is in SQL Server 2005, and when I finally did figure it out I figured this might help someone. Open Start -> SQL Server…
-
Navision sync error with Cluster SQL 2005
Hi, This is Navision SP2 with SQL 2005. After migrated Navision SP2 to SQL 2005 we started to have problems with the SQL name. SQL2 is the name of the Windows 2005 Server Cluster, and SQL2VS is the name of the clustered SQL 2005 Server instance that runs on that server. Navision always looks at the SQL2 which is the…
-
SQL server 2005 Developer Edition-Server not visible on LAN
I am trying to get a SQL Server 2005 server up and running with Navision 4 SP3. The Server is setup and I can acces the Navision database from the pc it the server is running on, BUT other clients on the LAN cannot find the server with Navision. Could this be because of the Developer Edition I have installed?
-
64 bit sql
Hello I had a question about 64 bit sql. I know that the application finsql.exe is 32 bit. but the sql server executable runs on 64 bit executable. Does sql stores the (indexes) in 64 bit? Ofcourse the data is stored in 32 bit, otherwise if you pass 2.1 billion entry no in GL Navision client won't accept it. So will…
-
NAV and partitioning in SQL 2005
Is it possible to use partitioning functionality of SQL 2005 on some highly populated tables of NAV for instance ledger tables? It would be ideal if we can horizontally partition those tables according to the date fields. It can be questioned why I do not myself try it out! It would mean a very hazardous adventure. If…
-
Restore sql db with linked table to native
All, we have a production sql database. There are some views defined in sql and in navision there are some tables linked to these views. Now when we do a navision backup, and want to do a restore to a native we get the error that table XXXXX doesn't exist. This table is the linked table. Is there a way to still restore…
-
Problem with SQL Server
Hello, I want to integrate a FOB on a sql server database and i got an error telling me that i can't modify the table "Country"...I thought it's due to user role but i'm connected with a SUPER user that have all permissions! What can be the problem?
-
Problem with Restore
I have a database with a linked table (SQL view) and am attempting a Navision restore onto another server (3.7 to 4.03 - SQL 2000 - SQL 2005). I have created the view on the new server. When the restore runs I get the error "TableData xxxxx does not exist".
-
Restoring backup on SQL 2K5
Hello Client has 50 companies on sql. Restoring a company from Nav backup (12K) goes through the process and at the end after it deletes the tables in million range, it hangs for several hours and then finishes. Anybody has seen this or knows why this happens?
-
Sync error - space
Hi, This is Nav SP2 with SQL 2005. During the sync, we got this error " 1105, "4200" [microsoft] [ODBC SQL Driver] [SQL server] could not allocate space for object 'sys.sysprivs'.'clust' in database'Navision' because the 'primary'filegroup is full. Create disk space by deleting unnedded files, dropping objects in the…
-
Navision going to SQL 2000 SP4
Hello, I was wondering if anyone knows of any issues of Navision 3.7 going into SQL 2000 SP4 as opposed to SP3A? Thanks TD
-
SQL Tips & Tricks
May it interesting to open a new forum "Tips & Tricks" ... specially for SQL?
-
Windows 2000 server memory options
Good Morning, I am running Navision 3.70b on a dell poweredge 6600 with 6GB memory. The OS is windows 2000 server standard edition. I knew that there is a way to take the advantage of assigning more memory to my SQL 2000 server standard edition. But I could never find the proper way of doing it. Here is what I just found…
-
Has anyone tried SQL 2005 SP2?
I'm running Navision 4.0 SP3, and I'm considering to upgrade SQL 2005 to SP2. Anyone had any trouble with this?
-
SQL warning on NAV 4.0 SP1 SQL 2003
Can anyone shed some light on what the following warning has to do with? ========================== From: smartmonitor@doitsmarter.com [mailto:smartmonitor@doitsmarter.com] Sent: Monday, March 05, 2007 9:59 AM To: Support Subject: [-] : Critical : Expo Industries : exponav1.expo.local : [Thresh] SQL Server Batch Requests -…
-
New Forum!!
Question: will old related posts be moved here or is this just gonna start fresh & new as of today?
-
SQL Server - option values
Hi, I want to access our SQL Server option Navision via SQL Statements, but i need the value of an option, not the integer value. Does anyone know where i can find these, so i wouldn't have to hardcode them? Thx
-
Error trying to drop keys
hi, when trying to disable keys on a table this SQL error appears: Explicit @itemtype 'INDEX' is unrecognized (0) Anyone seen this before or knows what it is about? It's in a turkish 3.70 database. Any thoughts are appreciated.
-
Migrating to SQL - Changing SQL data type
I'm trying to migrate a Native Navision 3.7 to SQL option, I stick to 3.7. I used the migrate.fob and the documentation says to open the form Code Field Information. I opened this form and want to change the SQL Data Type for some of the rows as indicated in the documentation only I cannot change the type, it stays put to…
-
SQL 2005 Reporting Services - Report Model
I've just bought the SQL 2005 Reporting Services for Dummies book, which is usually enough to get my feet wet and then with some playing around I figure things out. The question is... Has anyone made a Report Model for Navision? and then following on, did you have to create views or use OLAP from Analysis Services? I tried…
-
Where is MS word on SQL 2005?
Can someone point me towards MS's statement that SQL 2005 "only" works for 4.01 and upwards? Would be nice to be able to tell our customer : "Lookie here, MS says that you have to run at least 4.01 in order to utilize SQL 2005" Yes, i know I can make various technical modifications and then have earlier NAV runnning. But I…
-
SQL 64 bit - is this configuration supported by Microsoft?
I have question about this configuration: Navision 4.01 latest SP on 32 bit Windows XP connected to SQL 64 bit on Windows 2003 64 bit – is this configuration supported by Microsoft? I would like to use Windows Integrated logins.
-
Upgrade 3.7a - 4.0sp3 on SQL
Hi, Breakdown: Nav 3.7a on SQL v8.0 upgrading to Nav 4.0sp3 on SQL 2005 Does this sound problematic already? ;) The upgrade was going fine up until the Database Test on the upgraded database laying on the new SQL version. (Step 18 in the 370_400 Quickguides document for the Upgrade Toolkit). The database test hangs when…
-
Czech and German in a SQL Database
Hello, what for Properties must be set that start Navision 4.02 of SQL 2005 with German and Czech? Have anywhere running this system? Dennis
-
Shrinking an SQL Database
What are the ramifications of shrinking an SQL database?
-
SQL Server Client Access License (CAL)
Hi I think there is quite a lot confusion arround this theme. At least I think it is quite complicated to buy the best (legally and monetary) sql license. What is your approach to select the best sql license for different scenarios, let's say:SQL Server for Navision onlySQL Server for Navision and other apps Additional…
-
Collation on Navision 4.0 SP3 with SQL 2005
Hi I have a problem, when I try to enable the MaintainSIFTIndex for the "Cust. Ledger Entry" I get the following error : Error 468, Cannot resolve the collation between "Danish_Norwegian_CI_AS" and "Danish_Norwegian_CI_AI" in the equal to operation. I hope that someone can explain why this error occurs. ](*,) I Have tried…