Browse by Tags

production dbase user mapping is disabled in SQL Server after synchchronizing Navision users

Normal 0 false false false EN-US X-NONE X-NONE MicrosoftInternetExplorer4 /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-priority:99; mso-style-qformat:yes; mso-style-parent:"";...

Posted to NAV / Navision - Microsoft SQL Server (Forum) by richsara on 08-14-2008
Navision Database restore in SQL Server 2005- facing issue with stored procedure

We are using Navision 4.0(SP3). I am new to Navision and Database Administartion. I got restored the Navision production database backup (SQL Server 2005) in to our testing environment. Everything works fine from when I setup the application from the restored database but I am not able to execute any...

Posted to NAV / Navision - Microsoft SQL Server (Forum) by nvasuki on 08-06-2008
Navision 4.0(SP3) - facing problem with database restore

We are using Navision 4.0(SP3). I am new to Navision and Database Administartion. I got restored the Navision production database backup (SQL Server 2005) in to our testing environment. Everything works fine from when I setup the application from the restored database but I am not able to execute any...

Posted to NAV / Navision - Developers Forum (Forum) by nvasuki on 08-06-2008
Querying Comments Fields

Anyone have any experience in using a SQL query to pull back information from navision comments/details fields? My nav developer has implemented the "Waldo Text Pad" object - http://www.mibuso.com/dlinfo.asp?FileID=335 I understand nav stores each line of text as individual records in the database...

Posted to NAV / Navision - Developers Forum (Forum) by jamie1984 on 07-09-2008
Cannot rename table - published for replication

I'm trying to rename a company but I'm getting this error: " Cannot rename the table because it is published for replication " And then it points me to the Salesperson/Purchaser table. The NAV version is 4.00 SP3 on a SQL Server 2005. To my knowledge we have not setup any replication...

Posted to NAV / Navision - Technical Forum (Forum) by Erik P. Ernst on 06-12-2008
Problem Selecting Original DateFormula using Excel VBA

I am using JetReports to generate most of my reports. For some of them, I am also using VBA and ADO to get the result directly from SQL Server 2005 database and import it into Excel . The problem I have been having with the latter is that if I need to get the value of a field that has DateFormula (1W...

Posted to NAV / Navision - Microsoft SQL Server (Forum) by sdhusodo on 06-11-2008
Navision 4 SP 3 - SQL 2005 Synchronization Issues

Hi, Is it possible to sync the Navision database logins using a login other than SA? Is it possible to assign a specific user's login to sync all the Navision database users? If yes, can anyone please explain about the database and server roles that has to be assigned for this login. The scenario...

Posted to NAV / Navision - Technical Forum (Forum) by Vinod on 05-26-2008
Recommendation for Right Memory Settings (AWE, PAE, 3GB)

I am looking for a recommendation or an overview for the memory settings in the OS and SQL-Server in different versions. What do I have to activate in the boot.ini when I have 4 GB or 8GB Memory, when I have Windows-Server 2003 Standard, Enterprise in 32 or 64 bit. What do I have to avtivate in SQL-Server2005...

Posted to NAV / Navision - Microsoft SQL Server (Forum) by jbruentrup on 05-13-2008
Sales Invoicing and Shipment grinding to a halt

We have implemented Navision in several sites and are beginning to see performance issues each of these sites. All sites are running SQL server 2005, and windows 2003. Hardware is as per the HW guide and if anything we have future proved by over specing the HW. Transactions are roughly in the vicinty...

Posted to NAV / Navision - Microsoft SQL Server (Forum) by dekka22 on 05-02-2008
Re: Move Navision Database from SQL 2000 to SQL 2005

Hi, We made a move from SQL2000 to SQL2005 and an upgrade from NAV 3.7 to NAV 5.0. We installed a new server with SQL2005 and NAV 5.0. I have made a backup in NAV 3.7 (.fbk) and restored this file in an empty database NAV 5.0 (be sure the codeset of the database is the similar to the old one). Afterwards...

Posted to NAV / Navision - Technical Forum (Forum) by avandermuur on 04-24-2008

Page 1 of 14 (135 items) 1 2 3 4 5 Next > ... Last »