Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.5K Microsoft Dynamics NAV
- 18.5K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 115 Navision DOS
- 854 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 615 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 269 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 992 SQL General
- 384 SQL Performance
- 33 SQL Tips & Tricks
- 34 Design Patterns (General & Best Practices)
- Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.7K General
- 1.1K General Chat
- 1.6K Website
- 79 Testing
- 1.2K Download section
- 23 How Tos section
- 259 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Options
Upgrade SQL Server 2000 to SP3 With Navision 4.0 Database
estamatis
Member Posts: 3
I have a navision 4.0 database on a SQL Server 2000 (with no Service pack on the sql and the navision).
I want to upgrade SQL Server 2000 to SP3. Do i have to upgrade Navision 4.0 to Sp3 to ?
Is Navision 4.0 with no SP works with SQL Server 2003 with SP3?
I have tested both senarios SQL Server With or Without SP3 and Navision With and without sp3 and all worked fine.
Is there any know issue with SQL Server 2000 SP3?
Thanks
I want to upgrade SQL Server 2000 to SP3. Do i have to upgrade Navision 4.0 to Sp3 to ?
Is Navision 4.0 with no SP works with SQL Server 2003 with SP3?
I have tested both senarios SQL Server With or Without SP3 and Navision With and without sp3 and all worked fine.
Is there any know issue with SQL Server 2000 SP3?
Thanks
0
Comments
Oh, did I mention Navision uses cursors for all reads on the DB?
2 good advices:
-install SP4 on SQL2000 with the latest hotfixes. (Navision doesn't care about the SQL version. It will always work)
-upgrade Navision to 400SP3 with latest hotfix.
[Topic moved from Navision forum to SQL General forum]
No PM,please use the forum. || May the <SOLVED>-attribute be in your title!
The performance problems with cursors are on SQL2000SP3 and not to the previous versions of SQL? If the non SP version of SQL20000 (this one that i currently use) have the same performance problems with the SP3 then it is alright for us. Or the SP3 will make performance worst than it is right now?
I ask this because on the same sql server i have another non navision database that have ansolved issues with SP4.... and that 's why i want to upgrade to SP3.
any suggestion ?
But in general it is best to have the latest SP and hotfix.
And it is also advisable to have a dedicated server for performance. Remember that if one DB is using some resource, the other cannot use it at the same time.
If your other DB is using very little resources because it is used rarely, you can keep it on the same server, but otherwise....
No PM,please use the forum. || May the <SOLVED>-attribute be in your title!