We have a non-prod and prod servers are in RTM now...
We are planning to move them to SP2, So what are the advantages will get?
asked Oct 01, 2012 at 04:45 PM in Default
Support of database mirroring, improvements to the query optimizer just to name two.
answered Oct 01, 2012 at 04:53 PM
You really want to go all the way up to SP4 in order to get back into mainstream support.
Yes, with SP2 you will get bug fixes... any that were included in SP1 and SP2, since all bug fixes are cumulative. You will also get database mirroring, as that was turned on in SP1. I believe you also get the ability to run reports from SSMS (if you're running the SP2 where the SQL Server client tools are installed).
However, there are a whole slew of bug fixes in SP3 and SP4, plus that puts you in good stead in case there is a security issue. Microsoft won't release a patch for SP2. Not a good situation to be in.
answered Oct 03, 2012 at 12:50 PM
K. Brian Kelley