Unable to locate Select Into/Bulk Copy and Truncate Log on Checkpoint parameters

Technical Note USA11025
Created 09-Sep-2004

Applies To
DATABridge Clients 4.2

Microsoft SQL Server 2000

Select Into/Bulk Copy parameter

Truncate Log on Checkpoint parameter

Symptoms

Unable to locate Select Into/Bulk Copy and Truncate Log on Checkpoint parameters

Parameters were available in Microsoft SQL Server 7

Not sure how to check the parameters on as indicated in the DATABridge documentation

Fix

Microsoft SQL Server 2000 handles log file sizing internally.  There is no way to set these parameters in Microsoft SQL Server 2000.  The only way to handle the transaction log file getting too big is to back it up and then empty it.