BUG: Distribution Agent Parameters Listed After -QuotedIdentifier Are Ignored (307930)

Microsoft SQL Server 2000 (all editions)

Microsoft SQL Server 7.0

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 """ -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 """

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.

Modification Type:

Major

Last Reviewed:

10/16/2003

Keywords:

kbbug kbpending KB307930