PRSQL9202004: ISQL GP Fault/SAF Hang Loading Large Image Data

ID Number: Q80637

1.11

OS/2

buglist1.11

Summary:

Problem ID: PRSQL9202004

SYMPTOMS

When trying to pipe a script file with large image data to ISQL to

insert into a table with an image column, SQL Server GP faults.

When executing the same query within the System Administration

Factility (SAF), SAF hangs.

CAUSE

This problem occurs when the size of the image data to be inserted

is larger than 2K.

WORKAROUND

To work around this problem, use the Bulk Copy Program (BCP) to

import large image data into the SQL Server.

STATUS

Microsoft has confirmed this to be a problem in SQL Server version

1.11. This problem does not occur in SQL Server version 4.2.

Additional reference words: 1.11 GP-fault