RE: [development-axapta] Who locks the table?

2008-01-23 Thread James Flavell 
The online users screen shows I think
 

  _  

From: development-axapta@yahoogroups.com
[mailto:[EMAIL PROTECTED] On Behalf Of jquinteroz
Sent: Wednesday, January 23, 2008 9:56 AM
To: development-axapta@yahoogroups.com
Subject: [development-axapta] Who locks the table?



Hi:

We recently had had some issues with record blocking (lock).
We can see the SPID of locked tables...but how we can
know which user is doing that (locking the table).

Regards.



 


[Non-text portions of this message have been removed]

RE: [development-axapta] Who locks the table?

2008-01-23 Thread larrybellou Bellou 
Yes, go to Administration, then Online Users and sort by SPID to find the 
one you are looking for.  Please note in SQL Server which AOS (Server) it is 
coming from.  Because it is only online users for that AOS (at least in AX3.0). 
 Make sure you are on the correct AOS.Thanks! Larry Bellou 


To: [EMAIL PROTECTED]: [EMAIL PROTECTED]: Wed, 23 Jan 2008 19:12:02 
+0800Subject: RE: [development-axapta] Who locks the table?




The online users screen shows I think_ From: [EMAIL PROTECTED]:[EMAIL 
PROTECTED] On Behalf Of jquinterozSent: Wednesday, January 23, 2008 9:56 AMTo: 
[EMAIL PROTECTED]: [development-axapta] Who locks the table?Hi:We recently had 
had some issues with record blocking (lock).We can see the SPID of locked 
tables...but how we canknow which user is doing that (locking the 
table).Regards.[Non-text portions of this message have been removed] 






_
Shed those extra pounds with MSN and The Biggest Loser!
http://biggestloser.msn.com/

[Non-text portions of this message have been removed]