In MS.SQL 2000 Server, I usually can monitor Lock Process from enterprise manager (Management - Current Activity - Lock / Process ID)
Now I am using MS. SQL 2008 express edition and I cannot find any feature to monitor this from Management Studio, is it because I use Express Edition?
1. on what edition this feature will show up in Management Studio? is Standard Edition already has this feature?
2. How to monitor the lock process with SQL 2008 Express edition?
3. How to kill lock process in SQL 2008 Express Edition?