Okay to install sp3a over sp3?

We intended to install sp3a but ended up installing sp3 by mistake. According to the web site, if you have installed sp3, "you don't need to install sp3a," but my question is would there be any harm in doing so? We know that an 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 have 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 problem 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 sp3
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:
sql

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:
>

ok to install sql2005/2000,vs2005/2003 on same machine

Hi just wondering if anyone has run into any problems installing and running
vs2005 and sql 2005 prof with a machine that already has sql2000 and vs2003,
or if it will effect sql 2000 or vs2003 in any way, thanks.
--
Paul G
Software engineer.I run this configuration. It does work. I installed a certificate on my web
server and suddenly I couldn't connect to SQL 2000 anymore. Other than that
it was working well.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Paul" <Paul@.discussions.microsoft.com> wrote in message
news:A323C6DA-764B-4298-9CBB-3E751F55DD0F@.microsoft.com...
> Hi just wondering if anyone has run into any problems installing and
> running
> vs2005 and sql 2005 prof with a machine that already has sql2000 and
> vs2003,
> or if it will effect sql 2000 or vs2003 in any way, thanks.
> --
> Paul G
> Software engineer.|||thanks for the response. I think I am having problems with the installation
.
For components to install it lists SQL Server Database Services, Analysis
Services, Reporting Services, Integration Services, Workstations Components,
Books online and development tools. It seems to install without error but I
do not see SQL server management studio from the programs list.
--
Paul G
Software engineer.
"Hilary Cotter" wrote:

> I run this configuration. It does work. I installed a certificate on my we
b
> server and suddenly I couldn't connect to SQL 2000 anymore. Other than tha
t
> it was working well.
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
> "Paul" <Paul@.discussions.microsoft.com> wrote in message
> news:A323C6DA-764B-4298-9CBB-3E751F55DD0F@.microsoft.com...
>
>|||Chances are this is because you installed SQL Express with Visual Studio
before you installed SQL Server 2005. This leaves you with the SQL Express
client utilities which don't include Management Studio. Try uninstalling
the client utilities and then reinstalling them from the full SQL Server
2005 release.
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"Paul" <Paul@.discussions.microsoft.com> wrote in message
news:CB9FDA44-C306-4A28-B054-D3CA726A5936@.microsoft.com...[vbcol=seagreen]
> thanks for the response. I think I am having problems with the
> installation.
> For components to install it lists SQL Server Database Services, Analysis
> Services, Reporting Services, Integration Services, Workstations
> Components,
> Books online and development tools. It seems to install without error but
> I
> do not see SQL server management studio from the programs list.
> --
> Paul G
> Software engineer.
>
> "Hilary Cotter" wrote:
>|||ok thanks that seemed to work!
--
Paul G
Software engineer.
"Roger Wolter[MSFT]" wrote:

> Chances are this is because you installed SQL Express with Visual Studio
> before you installed SQL Server 2005. This leaves you with the SQL Expres
s
> client utilities which don't include Management Studio. Try uninstalling
> the client utilities and then reinstalling them from the full SQL Server
> 2005 release.
> --
> This posting is provided "AS IS" with no warranties, and confers no rights
.
> Use of included script samples are subject to the terms specified at
> http://www.microsoft.com/info/cpyright.htm
> "Paul" <Paul@.discussions.microsoft.com> wrote in message
> news:CB9FDA44-C306-4A28-B054-D3CA726A5936@.microsoft.com...
>
>sql

ok to install sql2005/2000,vs2005/2003 on same machine

Hi just wondering if anyone has run into any problems installing and running
vs2005 and sql 2005 prof with a machine that already has sql2000 and vs2003,
or if it will effect sql 2000 or vs2003 in any way, thanks.
--
Paul G
Software engineer.I run this configuration. It does work. I installed a certificate on my web
server and suddenly I couldn't connect to SQL 2000 anymore. Other than that
it was working well.
--
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Paul" <Paul@.discussions.microsoft.com> wrote in message
news:A323C6DA-764B-4298-9CBB-3E751F55DD0F@.microsoft.com...
> Hi just wondering if anyone has run into any problems installing and
> running
> vs2005 and sql 2005 prof with a machine that already has sql2000 and
> vs2003,
> or if it will effect sql 2000 or vs2003 in any way, thanks.
> --
> Paul G
> Software engineer.|||thanks for the response. I think I am having problems with the installation.
For components to install it lists SQL Server Database Services, Analysis
Services, Reporting Services, Integration Services, Workstations Components,
Books online and development tools. It seems to install without error but I
do not see SQL server management studio from the programs list.
--
Paul G
Software engineer.
"Hilary Cotter" wrote:
> I run this configuration. It does work. I installed a certificate on my web
> server and suddenly I couldn't connect to SQL 2000 anymore. Other than that
> it was working well.
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
> "Paul" <Paul@.discussions.microsoft.com> wrote in message
> news:A323C6DA-764B-4298-9CBB-3E751F55DD0F@.microsoft.com...
> > Hi just wondering if anyone has run into any problems installing and
> > running
> > vs2005 and sql 2005 prof with a machine that already has sql2000 and
> > vs2003,
> > or if it will effect sql 2000 or vs2003 in any way, thanks.
> > --
> > Paul G
> > Software engineer.
>
>|||Chances are this is because you installed SQL Express with Visual Studio
before you installed SQL Server 2005. This leaves you with the SQL Express
client utilities which don't include Management Studio. Try uninstalling
the client utilities and then reinstalling them from the full SQL Server
2005 release.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"Paul" <Paul@.discussions.microsoft.com> wrote in message
news:CB9FDA44-C306-4A28-B054-D3CA726A5936@.microsoft.com...
> thanks for the response. I think I am having problems with the
> installation.
> For components to install it lists SQL Server Database Services, Analysis
> Services, Reporting Services, Integration Services, Workstations
> Components,
> Books online and development tools. It seems to install without error but
> I
> do not see SQL server management studio from the programs list.
> --
> Paul G
> Software engineer.
>
> "Hilary Cotter" wrote:
>> I run this configuration. It does work. I installed a certificate on my
>> web
>> server and suddenly I couldn't connect to SQL 2000 anymore. Other than
>> that
>> it was working well.
>> --
>> Hilary Cotter
>> Looking for a SQL Server replication book?
>> http://www.nwsu.com/0974973602.html
>> Looking for a FAQ on Indexing Services/SQL FTS
>> http://www.indexserverfaq.com
>> "Paul" <Paul@.discussions.microsoft.com> wrote in message
>> news:A323C6DA-764B-4298-9CBB-3E751F55DD0F@.microsoft.com...
>> > Hi just wondering if anyone has run into any problems installing and
>> > running
>> > vs2005 and sql 2005 prof with a machine that already has sql2000 and
>> > vs2003,
>> > or if it will effect sql 2000 or vs2003 in any way, thanks.
>> > --
>> > Paul G
>> > Software engineer.
>>|||ok thanks that seemed to work!
--
Paul G
Software engineer.
"Roger Wolter[MSFT]" wrote:
> Chances are this is because you installed SQL Express with Visual Studio
> before you installed SQL Server 2005. This leaves you with the SQL Express
> client utilities which don't include Management Studio. Try uninstalling
> the client utilities and then reinstalling them from the full SQL Server
> 2005 release.
> --
> This posting is provided "AS IS" with no warranties, and confers no rights.
> Use of included script samples are subject to the terms specified at
> http://www.microsoft.com/info/cpyright.htm
> "Paul" <Paul@.discussions.microsoft.com> wrote in message
> news:CB9FDA44-C306-4A28-B054-D3CA726A5936@.microsoft.com...
> > thanks for the response. I think I am having problems with the
> > installation.
> > For components to install it lists SQL Server Database Services, Analysis
> > Services, Reporting Services, Integration Services, Workstations
> > Components,
> > Books online and development tools. It seems to install without error but
> > I
> > do not see SQL server management studio from the programs list.
> > --
> > Paul G
> > Software engineer.
> >
> >
> > "Hilary Cotter" wrote:
> >
> >> I run this configuration. It does work. I installed a certificate on my
> >> web
> >> server and suddenly I couldn't connect to SQL 2000 anymore. Other than
> >> that
> >> it was working well.
> >>
> >> --
> >> Hilary Cotter
> >> Looking for a SQL Server replication book?
> >> http://www.nwsu.com/0974973602.html
> >>
> >> Looking for a FAQ on Indexing Services/SQL FTS
> >> http://www.indexserverfaq.com
> >>
> >> "Paul" <Paul@.discussions.microsoft.com> wrote in message
> >> news:A323C6DA-764B-4298-9CBB-3E751F55DD0F@.microsoft.com...
> >> > Hi just wondering if anyone has run into any problems installing and
> >> > running
> >> > vs2005 and sql 2005 prof with a machine that already has sql2000 and
> >> > vs2003,
> >> > or if it will effect sql 2000 or vs2003 in any way, thanks.
> >> > --
> >> > Paul G
> >> > Software engineer.
> >>
> >>
> >>
>
>