Hey, if you need any local assistance when you're in Vancouver give me
a shout. Of course, next week I'll be in LA. They're trying to convert
me to the dark side and I'm looking for some part-time contracts in
the MV world
Hth
Colin Alfke
Calgary, Canada
-Original Message-
by Ray
(as usual), currently in Dallas (Texas),
next week in Vancouver.
Regards,
Ray
- Original Message -
From: Sara Burns [EMAIL PROTECTED]
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] UV - Transaction Logging - Stale Transactions
Date: Tue, 27 Mar 2007 22:46:08 +1200
Thanks for your
Thanks for your responses.
The application is a mixture of mainly old and a few new programs. Some
of the new programs do use Begin Transaction, Commit, End Transaction
etc, but the vast majority do not. We use a number of SQL select
statements, but very few SQL update statements.
Files are
Are you using logical transactions? I.e., basic TRANSACTION
START/COMMIT?
Or SQL SELECT? That will automatically start a transaction (on 10.0.16
anyway) and hold it open until the SELECT ends, even tho no updates
occur.
If logs fill while a logical transaction is in process, the log will
remain
-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Stevenson,
Charles
Sent: Monday, March 26, 2007 1:26 PM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] UV - Transaction Logging - Stale Transactions
Are you using logical transactions? I.e., basic TRANSACTION
START/COMMIT
Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Stevenson,
Charles
Sent: Monday, March 26, 2007 1:26 PM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] UV - Transaction Logging - Stale Transactions
Are you using logical transactions? I.e., basic TRANSACTION
START/COMMIT