Applying Service Packs

When applying service packs to SQL Server (2000 or 2005), does the service
pack need to be applied to the client tools running on indivdual PCs/Laptops
as well? Thanks.Hello,
May not be required to all desktops. You can install the service packs to
the desktop machines when ever there is a requirement araise.
Thanks
Hari
"MACason" <MACason@.discussions.microsoft.com> wrote in message
news:1774B40F-32F8-4A01-8E4B-4C1C381FBE25@.microsoft.com...
> When applying service packs to SQL Server (2000 or 2005), does the service
> pack need to be applied to the client tools running on indivdual
> PCs/Laptops
> as well? Thanks.|||Hari Prasad wrote:
> Hello,
> May not be required to all desktops. You can install the service packs to
> the desktop machines when ever there is a requirement araise.
> Thanks
> Hari
> "MACason" <MACason@.discussions.microsoft.com> wrote in message
> news:1774B40F-32F8-4A01-8E4B-4C1C381FBE25@.microsoft.com...
>
If you are running SQL2000 Analysis Services and upgrade to AS SP4,
you'll have to upgrade your AS Analysis Manager and client tools to SP 4
as well. If you don't do it, you'll get some strange errors when you try
to connect with the client tools. I'm not aware of any other scenarios
where it causes problems to run a lower SP level on the client, but
there might be...;-).
--
Regards
Steen Schlter Persson
Database Administrator / System Administrator|||Please remember that DTS, as an example, is a client tool. If you have
different version of the client on your workstation and your server you run
the risk of getting totally different DTS packages and therefore results.
In SQL2005 the maintenance plans have changed dramatically between SP1 and
SP2. You cannot administer an SP2 created plan with an SP1 client. If a plan
is created on an SP2 server then you would not be able to maintain it from
an SP1 client.
Our rule is to update the client software when the client accesses an
updated server.
Chris
"MACason" <MACason@.discussions.microsoft.com> wrote in message
news:1774B40F-32F8-4A01-8E4B-4C1C381FBE25@.microsoft.com...
> When applying service packs to SQL Server (2000 or 2005), does the service
> pack need to be applied to the client tools running on indivdual
> PCs/Laptops
> as well? Thanks.