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