Crystal Reports with SQL Server 2005: Setting Transaction Isolation Level?

I was able to embed this in a Command object.

I was able to embed this in a Command object: SET TRANSACTION ISOLATION LEVEL REPEATABLE READ --Command objects need to return a value SELECT GetDate() This Command object was in addition to the query that I 'wrote' in the Database Expert. Will you elaborate on the necessity of setting the ISOLATION LEVEL?

Thanks for the answer! Will the command execute before the real query and in the same connection (transaction isolation levels are on a connection-by-connection basis)? I tried adding this to a new report and Crystal Reports gave me the "Your current link configuration contains multiple starting points" warning, thereby making me wonder which executes first.

– Adam Paynter Nov 20 '09 at 16:54 I wish to set the transaction isolation level because one of our reports has a long-running query (~2 minutes) that selects all rows from an often-used table. Because this locks (shared locks) every row in this often-used table, no one else is able to update it until the query completes. – Adam Paynter Nov 20 '09 at 16:55 Honestly, I don't know when it will execute relative to the 'main' query.Is this something you can test?

Another thought: perhaps you could create a special account for queries generated by reports and set this accounts isolation level. – craig Nov 20 '09 at 17:27 I didn't think transaction isolation levels could be specified on a per-user basis.Do you have an example of how I would configure this for a report-specific user? – Adam Paynter Nov 20 '09 at 17:33 I don't.

I'm not even sure you could do it, but I thought I would mention it as an idea. A DBA should be able to answer this question. – craig Nov 20 '09 at 18:19.

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.