BUG: Only One Double-Quoted String Allowed in xp_cmdshell String (266224)


The information in this article applies to:

  • Microsoft SQL Server 7.0
  • Microsoft SQL Server 2000 (all editions)
This article was previously published under Q266224
BUG #: 58037 (SQLBUG_70)
BUG #: 217533 (SHILOH>

SYMPTOMS

Commands that are run by xp_cmdshell, which contain two or more parameters delimited by sets of double-quotes, do not run correctly. When you run the following command from the Query Analyzer: 
EXEC master..xp_cmdshell '"C:\whats this\prgm.exe" -i "c:\test dir\SQL.txt"'
the following error message occurs:
'C:\whats' is not recognized as an internal or external command.

WORKAROUND

Create a batch file to run the operations and then run that batch file by using xp_cmdshell.

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.
Modification Type:MajorLast Reviewed:10/17/2003
Keywords:kbBug kbpending KB266224
©2003 Microsoft Corporation. All rights reserved.