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
ass.
Sorry I can't help, I'm on the road (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
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 cop
-Original 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 TRANSACT
-
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?
Or
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 i