Friday, March 30, 2012

Okay to install sp3a over sp3?

We intended to install sp3a but ended up installing sp3 by mistake. Accordi
ng to the web site, if you have installed sp3, "you don't need to install sp
3a," but my question is would there be any harm in doing so? We know that a
n issue we're having is fix
ed in sp3a and we don't want to pull individual hotfixes.>> We know that an issue we're having is fixed in sp3a and we don't want to
pull individual hotfixes.
Which issue is that? AFAIK, there were no changes to the database engine
itself between sp3 and sp3a. The changes were in the setup program, MDAC
and net libraries.
A|||It's an issue with performance on a few ERP applications. We believe it is
due to MDAC 2.7 and will be fixed with MDAC 2.71a, as other ERP customers ha
ve posted along those lines. Would it make more sense/be possible simply to
upgrade MDAC instead of th
e SQL service pack? Or, as per my original question, will there be any prob
lem with just upgrading to sp3a?
"Aaron [SQL Server MVP]" wrote:

> pull individual hotfixes.
> Which issue is that? AFAIK, there were no changes to the database engine
> itself between sp3 and sp3a. The changes were in the setup program, MDAC
> and net libraries.
> A
>
>|||> Would it make more sense/be possible simply to upgrade MDAC instead of the
SQL service pack?
Yes!
http://www.aspfaq.com/
(Reverse address to reply.)|||Okay. But... If we still experience the issue, is it okay to go from sp
3
to sp3a?
"Aaron [SQL Server MVP]" wrote:

> SQL service pack?
> Yes!
> --
> http://www.aspfaq.com/
> (Reverse address to reply.)
>
>|||You're more than welcome to, but I really don't think that's going to solve
any performance issues.
http://www.aspfaq.com/
(Reverse address to reply.)
"smaas@.newsgroups.nospam" <smaasnewsgroupsnospam@.discussions.microsoft.com>
wrote in message news:265021CB-C08C-4054-B0CE-B5E53FA58F1C@.microsoft.com...[vbcol=seagreen]
> Okay. But... If we still experience the issue, is it okay to go from
> sp3
> to sp3a?
> "Aaron [SQL Server MVP]" wrote:
>

No comments:

Post a Comment