Re: SET TRANSACTION question
Peter
I do not have experience of the set transaction statement, but I do know that
if you
use SET ISOLATION, its effect lasts until you next explicitly change the
isolation.
SET ISOLATION has always worked in this way.
I would assume that SET TRANSACTION is working in the same fashion.
I would also suspect that the behaviour you refer to is only in operation
when the
database is created as MODE ANSI, but this is just a wild guess.
Mark
MarkDenham@aol.com (home)
Denham.M@amstr.com (work)