SQL Server Client Tools and Service Pack

  • After installing SQL Client Tools, should we install its service pack?

    Any input will be greatly appreciated.

  • Yes, definitely update to the latest service pack. And also make sure your client tools are at least the same version (if not greater) than any instance you are connecting to.

    This was really important in SQL Server 2005 on systems that were upgraded past SP2. There were a lot of changes made to maintenance plans in SP2 and if your client tools were not updated you couldn't work with them.

    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

Viewing 2 posts - 1 through 1 (of 1 total)

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