If these client computeres only access the server through ADO then the upgrade of MDAC will suffice. Other data access method have their own way of updating it.
If these client computers have the SQL Client Utilities (like Enterprise Manager, Query Analyzer, ...) then you must deploy the service pack.
>When we get SQL server servce package, we will run this on SQL SERVER computer to update. Do we need to run this package in each SQL client computers?
>
>If need, do we have easier way to do this instead to run on each computer?
>
>
>Thanks
>
>
>Jim
Éric Moreau, MCPD, Visual Developer - Visual Basic MVP
Conseiller Principal / Senior Consultant
Moer inc.
http://www.emoreau.com