Transaction Activity......

  • Thread starter Thread starter Frank
  • Start date Start date
F

Frank

I am using SQL Server 2000 and .Net Frame Work1.1.



I have implemented the transaction based activity using the following
syntax.

gtrnSQLDB = gcnnSQLDB.BeginTransaction(IsolationLevel.ReadUncommitted)

Since I am specifying the transaction level of "ReadUncommitted" and
in-between BEGIN and ROLLBACK if I call SELECT STATEMENT from some other
application for this particular record, will it be in the queue or will it
read the uncommitted data? or to read the uncommitted data do I have to use
additional statement in the SELECT statement?

I appreciate your reply,

Frank
 
Frank,

Other apps get readonly access i.e. they can read it but cannot change it.
If they try changing it, they will wait for CommandTimeOut and then get a
timeout exception, unless of course ur done before that.

For a fantastic treatise on Isolation levels, read my book - chapter #9 :-)

- Sahil Malik
You can reach me thru my blog at
http://www.dotnetjunkies.com/weblog/sahilmalik
 
Sahil Thanks for your reply.

When I read the data by regular select statements it is reading. I am
getting the error message when I try to execute a stored procedure which
internally uses select statements.

Here is the EXACT error message.

"Timeout expired. The timeout period elapsed prior to completion of the
operation or the server is not responding"

Please advice.

Frank
 
Yup. This means the SP is blocked for one or more reasons and timed out
waiting for something--probably your locked page. Is it trying to write? If
not, then it's being blocked by some other operation.

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
 
I noticed that the data I was reading had uncommitted data at that point of
time. For stored procedure I have added the following statement


SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED



It started working fine.



But If I replace this stored procedure with SQL statement in the code it
works fine.



Thanks for your analysis and reply.

Frank
 
Back
Top