Does client have to get sp4 too?

  • I updated our SQL Server with sp4 and then applied hotfix 2187 (the latest). However, I run queries/procs and design DTS packages using Query Analyzer and EM installed on my client/laptop. Does this cause a problem?

    By the way, many of my procs have OPENQUERY() to pull data from a Progress database.

    I'm going to apply sp4 to my laptop, but I was wondering if some locking issues related to tempdb/openquery/DTS jobs that have cropped up recently could be the result of my buidling procs/dts packages via my sql-sp3 client.

    Thanks

     


    smv929

  • Normally, we do not have to. But, since your server has installed SP4, you had better install SP4. Otherwise, you may not get full functions, such as openning a DTS.

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

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