SQL Server 2000 Table Locks
Sunday January 16, 2005
In a recent forum posting, JKENNBUSS wrote:
"We have an application that calls a Stored Proc to Insert data to a table. The table has three foreign keys used to relate three separate tables. The data being inserted only affects the main table. However, we are seeing that the other three tables go into a locked state even though there are no write actions.
We believe these locks are affecting other non-related processing.
Is this normal? Is there a way to avoid this behavior?"
Can you help? If so, stop by our forum today!
"We have an application that calls a Stored Proc to Insert data to a table. The table has three foreign keys used to relate three separate tables. The data being inserted only affects the main table. However, we are seeing that the other three tables go into a locked state even though there are no write actions.
We believe these locks are affecting other non-related processing.
Is this normal? Is there a way to avoid this behavior?"
Can you help? If so, stop by our forum today!
Comments
No comments yet. Leave a Comment