How can i use transaction safely in MSSQL 2000?

Posted on 2007-07-24
Medium Priority
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
ID: 19555501
In debugging mode, you are not allowed to make changes on those tables
LVL 14

Accepted Solution

puranik_p earned 2000 total points
ID: 19555510
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'.

Author Comment

ID: 19555564
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....

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

What if you have to shut down the entire Citrix infrastructure for hardware maintenance, software upgrades or "the unknown"? I developed this plan for "the unknown" and hope that it helps you as well. This article explains how to properly shut down …
Microsoft Access has a limit of 255 columns in a single table; SQL Server allows tables with over 255 columns, but reading that data is not necessarily simple.  The final solution for this task involved creating a custom text parser and then reading…
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.
Suggested Courses

839 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