FIX: Queue Reader Fails in SQL Server 2000 French Version (303300)
The information in this article applies to:
- Microsoft SQL Server 2000 (all editions)
This article was previously published under Q303300
BUG #: 351589 (SHILOH_BUGS)
SYMPTOMSNOTE: This article only applies to the French version of SQL Server 2000.
Queued Updating Transactional Replication with the French version of SQL Server 2000, causes the following error message to occur when you run the Queue Reader Agent:
Arret du Lecteur de l'Agent. L'etape a echoue
The error message appears in the history of the Queue Reader Agent. You can find the error message in the replication monitor of the SQL Server Enterprise Manager or in the MSqreader_history table in the distribution database.
If you start the Queue Reader from a command line with the Qrdrsvc.exe utility, the following error message displays:
Agent de lecture de file d'attente de replication Microsoft SQL Server
8.00.194 Copyright (c) 2000 Microsoft Corporation
L'Agent de lecture de file d'attente [JLN2004].8 (Id = 1) a demarre
Serveur: JLN2004, Base de donnees distribution: Erreur ODBC:Erreur de syntaxe
ou violation d'acces
Impossible de se connecter au distributeur local
Arret du Lecteur de file d'attente
Le processus est termine. Appuyez sur CTRL+C pour fermer la fenetre.
CAUSE
There is a syntax error being caused by quotes in the French comments that are used to update the Queue Reader history.
RESOLUTIONTo resolve this problem, obtain the latest service pack for SQL Server 2000. For additional information, click the following article number to view the article in the
Microsoft Knowledge Base:
290211 INF: How to Obtain the Latest SQL Server 2000 Service Pack
WORKAROUND
Use the US version of SQL Server 2000 on the distributor.
STATUSMicrosoft has confirmed that this is a problem in SQL Server 2000. This problem was first corrected in SQL Server 2000 Service Pack 1.
| Modification Type: | Major | Last Reviewed: | 10/3/2003 |
|---|
| Keywords: | kbBug kbfix kbSQLServ2000sp1fix KB303300 |
|---|
|