Has anyone tried SQL 2005 SP2?

jmacs
jmacs Member Posts: 7
edited 2007-03-07 in SQL General
I'm running Navision 4.0 SP3, and I'm considering to upgrade SQL 2005 to SP2.

Anyone had any trouble with this?

Comments

  • Nobody
    Nobody Member Posts: 93
    I have been using the beta for months and just just put on the GA release and it works great with NAV. Actually SP2 contains many cursor performance issues fixes especially with FFO cursors which NAV is a heavy user of. I would actually recommend anybody on NAV and SQL 2005 apply SP2.
  • jmacs
    jmacs Member Posts: 7
    Thanks. If you haven't checked it out yet, Microsoft has an add-in for WSS 3.0 or Sharepoint 2007 that lets you draw reports from reporting services. I find this a very attractive alternative to Navision's reporting envoironment, and we are heavy users of Sharepoint.
  • Waldo
    Waldo Member Posts: 3,412
    I did the upgrade at a major client of ours, and there were no performance improvements noticable ... .
    But for stability reasons, I would always apply the latest SP.

    Eric Wauters
    MVP - Microsoft Dynamics NAV
    My blog
  • kriki
    kriki Member, Moderator Posts: 9,121
    [Topic moved from Navision forum to SQL General forum]
    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!

  • Joe_Mathis
    Joe_Mathis Member Posts: 173
    I don't know how many people are aware that it's on Service Pack 2a.

    http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/servicepacks/sp2.mspx

    It fixes an issue with the maintenance plan scheduler. It was released on Monday. There was an issue with SP2.

    If you have already applied service pack 2 prior to March 5th, then you should read this KB to upgrade it to 2a.

    http://support.microsoft.com/kb/933508

    Joe
    Joe

    http://www.interdynbmi.com

Categories