September 4, 2008 at 10:03 am
how can i tell what tables are locked at any given time?
also, how can i identify which rows are locked in a table at any given time?
September 4, 2008 at 10:18 am
The sp_lock stored procedure is a good starting point as would be sys.dm_tran_locks. Or if you like the GUI you can go to SSMS -> Management -> Activity Monitor and select one of the Locks views.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
September 5, 2008 at 11:00 am
thank you
September 12, 2008 at 8:32 am
In SQL 2000 there was a way to prevent the lock on the TABLES - do you know where this setting could be in SQL 2005.
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply