>>I'm able to see which tables are locked but missed out on how to look for the commands that caused the locks. How do we see that from enterprise manager?
>
>That's in Management > Current Activity > Process Info. If you double click one of the entries, you see the last SQL statement. The process id here is the same one that you see in the Locks/Object and Locks/Process ID nodes.In fact, you can double click the line in the lock view, as well, to see the last statement on that connection.

Do you know if this is available in SSMS in SQL Server 2008 Express?

Thanks again.