Dnx_7
asked on
How can i use transaction safely in MSSQL 2000?
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?
regards
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?
regards
In debugging mode, you are not allowed to make changes on those tables
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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....
ok thank you puranik
aneeshattingal, i don't really understand your answer...
in debugging mode, you do what you want with those tables....