Post reply

Do you need to install SERVICE PACK on SQL Client Tool?

  • October 26, 2010 at 10:15 am

    #145995

    Please help= I am not sure if I have to install the sp2 on sql 2008 client server?

  • October 26, 2010 at 12:51 pm

    #1242505

    Yes. Some of those things get updated also.

    Wayne
    Microsoft Certified Master: SQL Server 2008
    Author - SQL Server T-SQL Recipes

    If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
    Links:
    For better assistance in answering your questions
    Performance Problems
    Common date/time routines
    Understanding and Using APPLY Part 1 & Part 2

  • October 26, 2010 at 2:43 pm

    #1242562

    Yes, you should always update the client tools to the highest version level (at least) of any systems you access.

    So, if you access a server with SP3 installed - you need your client tools patched up to that level. If you access a server with SP3 and cumulative updates you want those included on the client also.

    The only time you will have any issues is if you have to access pre-SP2 and post-SP2 servers and you are working with maintenance plans. If that is the case, I recommend upgrading the client tools and using RDP to access the pre-SP2 servers and use the client tools on the server.

    Jeffrey Williams
    “We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”

    ― Charles R. Swindoll

    How to post questions to get better answers faster
    Managing Transaction Logs

  • October 26, 2010 at 4:15 pm

    #1242592

    Thank you somuch for the respond....

  • October 27, 2010 at 10:46 am

    #1243055

    hydbadrose (10/26/2010)

    Please help= I am not sure if I have to install the sp2 on sql 2008 client server?

    Please try and post in the correct forum location, it avoids a lot of confusion!

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply