How can i use transaction safely in MSSQL 2000?

Posted on 2007-07-24
Last Modified: 2008-01-09
Hi experts

i use IDbConnection, IDbCommand etc... to query on my MSSQL database
it works fine and transaction too...

but, i have a question, when i use transaction in debug mode for example, table linked to transaction are freezed, no more application else can access those table...
so i tried to put the isolation level to the lowest one but any level cause same symptom : freeze working table/store procedure/view

anyone can help me?

Question by:Dnx_7
    LVL 75

    Expert Comment

    by:Aneesh Retnakaran
    In debugging mode, you are not allowed to make changes on those tables
    LVL 14

    Accepted Solution

    When you are doing any DML (insert/update/delete), the lock will be placed on the corresponding rows until you commit/rollback the transaction. Other transactions can only read the rows (again only if it is UNCOMMITTED READ). If other are trying DMLs, you can't escape the 'freeze working'.
    LVL 2

    Author Comment

    that make sense that DML are not allowed to keep data integrity...

    ok thank you puranik

    aneeshattingal, i don't really understand your answer...
    in debugging mode, you do what you want with those tables....

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Do You Know the 4 Main Threat Actor Types?

    Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

    Nowadays, some of developer are too much worried about data. Who is using data, who is updating it etc. etc. Because, data is more costlier in term of money and information. So security of data is focusing concern in days. Lets' understand the Au…
    JSON is being used more and more, besides XML, and you surely wanted to parse the data out into SQL instead of doing it in some Javascript. The below function in SQL Server can do the job for you, returning a quick table with the parsed data.
    Viewers will learn how the fundamental information of how to create a table.
    Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

    737 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

    20 Experts available now in Live!

    Get 1:1 Help Now