Re: ISOLATION LEVEL

On 26 Oct 98, at 21:00, John Kasprzyk wrote: > I thought the isolation level was 'committed read' not 'read committed'. It depends: there is now support for the ANSI terminology. SET TRANSACTION is roughly equivalent to SET ISOLATION, but what follows is laid out differently. So you would get something like SET TRANSACTION TO READ COMMITTED which is the same as SET ISOLATION TO COMMITTED READ... -- Ciao, Billy /Group Managing Director, The West Solutions Group: http://www.west.co.za \\ Drivel @ http://www.west.co.za/tasteless/ / \\ "Granted, Mr Wheeler's ideas are stupid and unreasonable, but he does own the company and I / think we should go along with him..." \\________________________________________________________________________________________________