Microsoft KB Archive/307930

= BUG: Distribution Agent Parameters Listed After -QuotedIdentifier Are Ignored =

Article ID: 307930

Article Last Modified on 10/16/2003

-

APPLIES TO


 * Microsoft SQL Server 2000 Standard Edition
 * Microsoft SQL Server 7.0 Standard Edition

-



This article was previously published under Q307930



BUG #: 355612 (SHILOH_BUGS)

BUG #: 102047 (SQLBUG_70)



SYMPTOMS
The parameters that you specify for the Distribution Agent may be ignored if you specify the -QuotedIdentifier parameter before the additional parameters.



WORKAROUND
Change the order of the parameters so that the -QuotedIdentifer parameter is listed last. For example, if the Distribution Agent parameters are: -Subscriber [Sub_ServerName] -SubscriberDB [pubs] -Publisher [DABORG11] -Distributor [Dist_ServerName] -DistributorSecurityMode 1 -PublisherDB [pubs] -Continuous  -QuotedIdentifier &quot;&quot;&quot; -Output c:\dist.txt -Outputverboselevel 3 Change the order of the parameters to: -Subscriber [Sub_ServerName] -SubscriberDB [pubs] -Publisher [DABORG11] -Distributor [Dist_ServerName] -DistributorSecurityMode 1 -PublisherDB [pubs] -Continuous  -Output c:\dist.txt -Outputverboselevel 3 -QuotedIdentifier &quot;&quot;&quot;



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

Microsoft has confirmed this to be a problem in SQL Server 7.0.

Keywords: kbbug kbpending KB307930

-

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

© Microsoft Corporation. All rights reserved.