To see the longest running transaction on your SQL Server instance, run the following statement. DBCC OPENTRAN If there are open transactions, DBCC OPENTRAN will provide a session_id (SPID) of the ...

Title question.<BR>I can't think of any reason why it would lock anything, seems like it's just deallocating space that has been marked as reusuable/not in use anyway, but just in case...do any locks ...