Microsoft KB Archive/228532

From BetaArchive Wiki
Knowledge Base


SMS: French Conv20.exe Fails to Convert SMS 1.2 Database When SQL 6.5 Is Set to Character Set 850

Article ID: 228532

Article Last Modified on 10/27/2006



APPLIES TO

  • Microsoft Systems Management Server 2.0 Standard Edition
  • Microsoft Systems Management Server 1.2 Standard Edition



This article was previously published under Q228532

SYMPTOMS

French Conv20.exe WILL NOT convert SMS 1.2 databases when the character set in SQL 6.5 is set to 850.

The following error is recorded in CONV20.log :

Creation en cours des requetes et regroupements par defaut... SQL Msg #170> Ligne 1: Syntaxe incorrecte au niveau de 'utilisateurs'.

CAUSE

An apostrophe used in a French description breaks the syntax of a SQL command.

WORKAROUND

To resolve this problem, obtain the latest service pack for Systems Management Server 2.0. For additional information, click the following article number to view the article in the Microsoft Knowledge Base:

236325 SMS: How to Obtain the Latest Systems Management Server 2.0 Service Pack




STATUS

Microsoft has confirmed that this is a problem in Systems Management Server 2.0. This problem was first corrected in Systems Management Server 2.0 Service Pack Service Pack 1.


Additional query words: prodsms

Keywords: kbbug kbfix kbqfe kbsms200fix KB228532