Gail,

I checked on Pervasive and I could not find any documentation on the ODBC supporting distributed transactions. I could not find any kind of configuration setting to change.

Any other thoughts...

Continuing..., I don't have this working yet.

The below does not work 'entirely'. As described in my reply to Gail there is some sort of promotion to a distributed transaction being...

Hi Gail,

I put the following around the statements I wanted to lock and I get no complaints during run time from two of the four similar sections in the same...

Thank you John. It's working great.

Warm regards,

Thank you Gail.

So just by putting BEGIN TRANSACTION and COMMIT TRANSACTION around the two operations no one else will be able to access table_A and get incomplete information. I am...

Thank you all, Prakash, Steve, Andras, Clive, Jeremy, and Andrew.

OMG, I needed all your ideas and questions. The critical issue has partially resolved itself almost as mysteriously as it appeared....

Steve,

We tried Log Rescue and have a question. If a procedure opens a cursor and brings in a result set of 100,000 records then enters a while loop which will...

Hi Steve,

Does Log Rescue show more than what we see in Enterprise Manager-SQL Server Logs?

Hi Matt and Jeff,

I don't have a combined table but can make one if necessary. I don't need to worry about displaying because the problem is apparently already invisible to...

Koji, thank you, the text on the web site is hard to see some things but I can assure you there is a single quote before the last parenthesis. I...

Ray, thank you, I did follow through on the printing and it was posted before your reply got posted. If you see anything I would appreciate it. When I cut...

Below are the declarations:

DECLARE @SQLString VARCHAR(8000)

DECLARE @SQLString1 VARCHAR(6000)

DECLARE @SQLString2 VARCHAR(50)

I have slightly change the last part of @SQLString to read:

from openquery(summit252007,''SELECT Loc_No,Div_No,Pay_Date,Freq,Pr_No,Spare,Summ_No,Emp_No,

Item_No,Ref_No,Check_No,Ss_No,Wcomp_1,Wcomp_2,Per_Start,

case

when Per_End like ''%-04-31%'' then datename(year,Per_End) + ''-05-01''

when...

additional note...

Everybody also says to pull all the data into a SQL Server temp table then insert from the temp table into the destination table. How is that faster, do...

Thank you Andras. This is perfect.

Warm regards,

Hope

Thank you Lowell. I did not know about timestamp. I have read now, however, that timestamp is not related to the date and time of an insert or change to...