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