Posted by mfanny on 05/29/06 03:17

Hi,

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.

Has anyone out there experienced this? Or does anyone know the
solution?

Thanks,
Mark

• Next in forum: Re: T-SQL CLOSE Connection to DB
• Prev in forum: sp_helprotect COLUMN has NULL value
• Thread view: Can't view Locks / Process ID

[Reply to this message]