Is there a way to know the lock history for a table?
In example, a list with all the locks that occurred on a table between 8:00 and 9:00.
Looking for answer that works on SQL Server 2000
You can only get current locks (eg syslocks). There is no lock history kept.
You'd have to run a SQL Profiler trace but it will generate a lot of data. Or poll syslocks periodically and store info in logging table.