Microsoft KB Archive/197243

= BUG: SQLExecutive, CmdExec Task Output Is Not Properly Reported =

Article ID: 197243

Article Last Modified on 10/3/2003

-

APPLIES TO


 * Microsoft SQL Server 6.5 Standard Edition

-



This article was previously published under Q197243



SYMPTOMS
The SQLExecutive, CmdExec task opens a file and redirects the stdout and stderr to it. When the task is complete SQLExecutive reads through the file in 231 byte increments. If the output is not on a boundary, > 231 bytes, the data is not reported.

For example, 245 bytes causes a second read loop to take place but the bytes read does not equal the requested buffer size of 231 bytes. The task ignores the second read and reports the first 231 bytes instead of the last 231 bytes.



WORKAROUND
To avoid the problem you can attempt to ensure that the output of the task is less than 231 bytes total or that the task output ends on a 231 byte boundary.



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



MORE INFORMATION
You can start SQLExecutive from the Windows NT command prompt using the following command  sqlexec -c [ASCII 150]v to see the actual output. However, the final output will not be reported in the task history correctly.

Additional query words: prodsql

Keywords: kbbug KB197243

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.