Has anyone tried SQL 2005 SP2?

jmacsjmacs 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

  • NobodyNobody 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.
  • jmacsjmacs 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.
  • WaldoWaldo 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
  • krikikriki Member, Moderator Posts: 9,094
    [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_MathisJoe_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
Sign In or Register to comment.