|
|
Posted by Erland Sommarskog on 05/30/06 00:51
(mfanny@gmail.com) writes:
> We have SQL 7 running on Windows 2000 Server. For some reason we are
> unable to view Locks / Process ID from workstations running Windows XP
> SP2 with Enterprise Manager. Nothing shows up in the window on the
> right. All it's says at the top of the window is "There are no items to
> show in this view" If we use Enterprise Manager on the server, we can
> view the Locks / Process ID. We can view both, Process Info and Locks /
> Object from the workstations and server, just not the Locks / Process
> ID. We used to, but I don't know what changed. I'm thinking it might
> have to do with upgrading to XP SP2, or a Windows update, but I'm not
> sure.
I find it a bit difficult to believe that Windows XP SP2 would matter,
at least when it comes to the communication with SQL Server. But maybe
some interaction with the MMC has broken.
If you use any Profiler, can you detect wether Locks / ProcessID generate
any calls to SQL Server?
--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
Navigation:
[Reply to this message]
|