Do any of the methods on this page work for you? Title: Displaying Locking Information (Database Engine) URL: http://technet.microsoft.com/en-us/library/ms177475(v=sql.105).aspx Chris On Thu, January 30, 2014 4:16 am, Darragh Ó Héiligh wrote:

Hello, I really urgently need a way of finding out if there are locks and what are causing them in SQL 2008R2.

The resource viewer or what ever it's called is really not accessible enough to get this information.

Thanks

_______________________________________________ Blind-sysadmins mailing list Blind-sysadmins@lists.hodgsonfamily.org http://lists.hodgsonfamily.org/listinfo/blind-sysadmins