471,318 Members | 1,980 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,318 software developers and data experts.

SQLTransaction locking up table

Hi All,

I am using a SQLTransaction in a .Net application to insert records
into a SQL Server table. At one time, there are 5000 or more records to
be inserted one by one. It takes some 20-25 mins for the entire process
to run.

Another application accesses the same table.

As long as the insert process within the transaction isn't completed,
the second application is not getting any response from the server. I
even tried to run a SELECT on the table in SQL Query Analyzer while the
insert process was running and it also did not respond till the time
the insert process finished!

Is this normal that a transaction is locking up a table? How do I
overcome it? I am using IsolationLevel.ReadUncommitted for the
SQLTransaction.

If I do not run the process within a SQLTransaction, the second process
or running the SELECT in Query Analyzer runs fine.

Thanks,
Sanjeev Mahajan

Jul 21 '05 #1
0 992

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

9 posts views Thread by john smile | last post: by
2 posts views Thread by mahajan.sanjeev | last post: by
5 posts views Thread by Swami Muthuvelu | last post: by
reply views Thread by mahajan.sanjeev | last post: by
3 posts views Thread by Neven Klofutar | last post: by
4 posts views Thread by perspolis | last post: by
2 posts views Thread by samuelberthelot | last post: by
reply views Thread by rosydwin | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.