Solved

MS-SQL Transaction locking whloe table

Posted on 2004-09-19
4
326 Views
Last Modified: 2012-06-21
Well I m using MS-SQL Server and having desktop application. When i applied SqlTransaction to insert a row in table it locks whole table
How its possible to prevent to lock whole table
thanx in advance
0
Comment
Question by:meharmahmood
  • 2
4 Comments
 
LVL 3

Accepted Solution

by:
mAjKoL earned 250 total points
ID: 12111726
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpref/html/frlrfSystemDataSqlClientSqlConnectionClassBeginTransactionTopic2.asp

Look at this one and use SqlConnection.BeginTransaction(IsolationLevel)
Set the Isolation Level that will be best for you.

HTH
0
 
LVL 3

Expert Comment

by:mAjKoL
ID: 12111749
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
array6 challenfge 6 81
Adding Namespace to the second node of the xml 16 62
Please explain: Aspect Oriented Programming 2 83
C# Error - Add Failed 12 78
Whether you’re a college noob or a soon-to-be pro, these tips are sure to help you in your journey to becoming a programming ninja and stand out from the crowd.
Computer science students often experience many of the same frustrations when going through their engineering courses. This article presents seven tips I found useful when completing a bachelors and masters degree in computing which I believe may he…
Viewers will learn how to properly install Eclipse with the necessary JDK, and will take a look at an introductory Java program. Download Eclipse installation zip file: Extract files from zip file: Download and install JDK 8: Open Eclipse and …
In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…

914 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now