Please start any new threads on our new 
    site at https://forums.sqlteam.com.  We've got lots of great SQL Server
    experts to answer whatever question you can come up with.
    
        | 
                
                    | 
                            
                                | Author | Topic |  
                                    | workaccountStarting Member
 
 
                                        4 Posts | 
                                            
                                            |  Posted - 2007-09-12 : 05:14:26 
 |  
                                            | Hi,First post. We run Microsoft Navision on our head office here with SQL server 2005. When our users get blocked it says "What ever table is blocked by another user". We want to be able to actually replace "another user" with the actual user name. Can anyone tell me how to do this?Thank you. |  |  
                                    | rmiaoMaster Smack Fu Yak Hacker
 
 
                                    7266 Posts | 
                                        
                                          |  Posted - 2007-09-12 : 23:21:46 
 |  
                                          | You can find that with 'sp_who2 active'. If want to change the way the app display, should contact vendor - Microsoft. |  
                                          |  |  |  
                                |  |  |  |