All Tags » sql server 2000 (Get this RSS feed)

Browse Site by Tags: sql server 2000

Showing related tags and posts across the entire site.

Navision 4.0 slow after migration from SQL 2000 to SQL 2005

After migration from the SQL server 2000 to SQL 2005 , Navision is slow for the sites that connect to the Database, The site where the server is has no problem when accessing the Database but those from the other sites with the same wide area has a problem accessing the database, What could be the possible...

Posted to Dynamics NAV / Navision - Microsoft SQL Server Forum by Michael AJ Nortey on Oct 14, 2009
Filed under: SQL Server 2005, SQL Server 2000
Re: migrate SQL Server 2000 to SQL Server 2008

The most important thing is to use the most recent build of your NAV version to make sure it is supported to run with SQL 2008. If you are just migrating a "normal" NAV database, then it is basically "detach DB 2000 - copy to SQL 2008 - attach DB 2008" - then adjust config (Compatibility...

Posted to Dynamics NAV / Navision - Microsoft SQL Server Forum by Jörg A. Stryk on Jul 10, 2009
Filed under: Performance, SQL Server 2000, NAV 4.0 SP3, SQL Server 2008, Migration
Restore an old SQL database

I have this copy of my old Navision 3.60 / SQL Server 2000 database from my old company BMI Partners, which I really want to pull out some data (customers/contacts and some reports). I have attached the database again to my SQL Server 2005 server. But now comes the tricky question. I remember my user...

Posted to Dynamics NAV / Navision - Microsoft SQL Server Forum by Erik P. Ernst on Jun 9, 2009
Filed under: Restore, SQL Server 2005, SQL Server 2000, Navision 3.60, Users
Navision 3.7 Optimize.

Hi Guys, I'm so happy to find this very helpful site,finally i'll get some help in MS NAV 3.7.Actually we are NAV 3.7B on SQL 2000.I have been struggling to maintain few tables in SQL,mainly the TRANS_ SALES ENTRY,TRANSACTION,BIN ENTRY and the most problematic ACTIONS tables,i set a SQL job to...

Posted to Dynamics NAV / Navision - Performance Optimization Forum by Ryan12007 on Jun 9, 2009
Filed under: Optimization, Performance, SQL Server, SQL Server 2000, Dynamics NAV, Navision 3.70
Microsoft Dynamics NAV 5.0 SP1 and SQL Server 2000

Microsoft Dynamics NAV 5.0 SP1 introduces a new way to handle SIFT. Instead of maintaining totals in separate tables, Dynamics NAV 5.0 SP1 uses a SQL feature called indexed views. Indexed views will automatically be maintained by the SQL Server. With SQL Server 2000, updating an indexed view can be a...

Posted to Microsoft Dynamics NAV Sustained Engineering Team Blog on Jun 3, 2008
Filed under: performance, NAV 5.0 SP1, SQL Server 2000
Hardware Guide for Dynamics NAV 4.0 - White Paper version 4.0

Microsoft Dynamics™ NAV 4.0 Hardware Guide for Dynamics - NAV White Paper Version 4 (August, 2007) Table of Contents Acknowledgements Legal Notice Purpose, Terms & Conditions Microsoft Dynamics™ NAV Environment Overview Microsoft Dynamics™ NAV Database Server Microsoft Dynamics™ NAV option for Microsoft...

Posted to NAV / Navision - Documentation, presentations and white papers by Erik P. Ernst on Oct 15, 2007
Filed under: NAV 4.0, SQL Server 2005, Hardware, performance, SQL Server 2000, Storage, Terminal Services, Remote Clients

Page 1 of 31 (620 items) 1 2 3 4 5 Next > ... Last »

Dynamics User Group

Browse Site by Tags: sql server 2000

Navision 4.0 slow after migration from SQL 2000 to SQL 2005

Re: migrate SQL Server 2000 to SQL Server 2008

Restore an old SQL database

Navision 3.7 Optimize.

Microsoft Dynamics NAV 5.0 SP1 and SQL Server 2000

Hardware Guide for Dynamics NAV 4.0 - White Paper version 4.0