Microsoft KB Archive/234200

= BUG: CMDExec Task May Cause Heap Corruption and AV in SQL Executive =

Article ID: 234200

Article Last Modified on 10/3/2003

-

APPLIES TO


 * Microsoft SQL Server 6.5 Service Pack 5a

-



This article was previously published under Q234200



BUG #: 18750 (SQLBUG_65)



SYMPTOMS
A CMDexec task may cause heap corruption if it contains an extra double quote ("). Repeated execution of the task may cause a SQL Executive Access Violation (AV). For example, a batch file named mybatch.cmd containing: isql -U"sa" -P -Q"SELECT 1" isql -U"sa" -P -Q"SELECT 1" isql -U"sa" -P -Q"SELECT 1" when executed as CMDexec task as mybatch.cmd, causes heap corruption and may cause an access violation.

If the double quotes are removed from around the sa characters in the preceding code, the problem does not occur: isql -Usa -P -Q"SELECT 1" isql -Usa -P -Q"SELECT 1" isql -Usa -P -Q"SELECT 1" This behavior occurs with the CMDEXEC.dll shipping with Service Pack 5, dated 8/26/98. It does not occur with previous versions of the file.



WORKAROUND
To work around this problem, choose either of the following:  Remove the extra double quotes.  Add "ECHO OFF" to the beginning of the batch file. For example: ECHO OFF isql -U"sa" -P -Q"SELECT 1" isql -U"sa" -P -Q"SELECT 1" isql -U"sa" -P -Q"SELECT 1" 



STATUS
Microsoft has confirmed this to be a problem in SQL Server version 6.5 Service Pack 5 and Service Pack 5a.



MORE INFORMATION
SQLTrace shows the extra double quotes introduced around the SELECT statement: msdb..sp_schedulerlog 0,0,0,17,"","",1,19990527,141240,4,"",0,0,"Process Exit Code 0. ...ected)    E:\MSSQL\BINN>isql -Usa -P -Q""select ""1""""                   ---              1     (1 row affected)    E:\MSSQL\BINN>isql -Usa -P -Q""select ""1""""                   ---              1     (1 row affected)  ",1684370531 The following message may appear if SQL Executive is started from the Command prompt with -c -v:

Application Error : Instruction at 0x77F7D40F referenced memory 0x00202020.

Keywords: kbbug kbpending KB234200

-

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

© Microsoft Corporation. All rights reserved.