Has anyone tried SQL 2005 SP2?

jmacs

I'm running Navision 4.0 SP3, and I'm considering to upgrade SQL 2005 to SP2.

Anyone had any trouble with this?

Nobody

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

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

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.

kriki

[Topic moved from Navision forum to SQL General forum]

Joe_Mathis

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