title: Find what rows are locked for a given table and who is locking them in SQL Server
body: <p>Is there a way to find out what rows are locked for a specific table in SQL Server 2008? I'd also like to know the user who is locking them.</p>