ID: Q194146
The information in this article applies to:
When using the Systems Management Server Administrator program to view the machine records of a Systems Management Server site, certain records that were previously present in the database may appear to have "disappeared" from the site. Upon closer inspection, you will see that missing data has been combined into another inventory record. By selecting the Previous History Record for the inventory record's Identification property, you may observe values relating to a "missing" machine record.
Microsoft SQL Server is configured to use character set 850 Multilingual and either sort order Scandinavian dictionary order, case-insensitive, uppercase preference (id 58), or sort order Scandinavian dictionary order, case-insensitive (id 60). By definition, these configurations do not differentiate between the characters "V" and "W".
Because the unique identifier for Systems Management Server clients (that is, the SMSID) takes advantage of each of the alphanumeric characters, a conflict arises whenever a site has two clients differentiated only by the single character V or W (for example, "SIT0100V" and "SIT0100W").
In this example, assuming that SIT0100V is written to the database first, when Inventory Data Loader attempts to add SIT0100W, the current record for SIT0100V will be added as a history record of SIT0100W. Therefore, the existing inventory record appears to have disappeared from the site database, until an inventory delta-MIF for SIT0100V is produced.
To work around this problem, set SQL Server to use a sort order that differentiates between these characters. To do this, perform complete the following steps, which apply specifically to SQL Server 6.5:
1. Make a complete backup of your system, according to the steps outlined
in Chapter 15 of the Systems Management Server Administrator's Guide.
server(s). You can use either the SMS Service Manager or Control Panel
Services to stop these services.
it for another sort order (that is, a sort order other than Scandinavian
dictionary order, case-insensitive with or without uppercase
preference).
NOTE: Because the Nordic sort orders available for the ISO character set
are not affected by this problem, you may also want to change the
character set you are using, in addition to changing the sort order.
installed during Step 3 of this procedure.
and the transaction log. Create the target database spanning the entire
space of these two devices. The size of these devices should be at least
as large as your SMS database on your current server.
Database/Object Transfer. Select the server that is currently holding
your SMS database as the source server and select the SMS database as
the source database. Make sure the destination SQL Server is selected
as the destination server and select the proper target database that you
created during Step 5 of this procedure. Then click Start Transfer.
transfer of some objects. For a resolution to these warnings, consult
the following article in the Microsoft Knowledge Base:
ARTICLE-ID: Q189588
TITLE : SMS: SQL Transfer Manager Errors When Moving SMS Database
SMS Database. Change the SQL Server name (and possibly SQL Server login
ID and password). Then click OK.
the selected changes. When it is done, click Close and then click Exit.
The system will now use the new SQL Server and database instead.
If you want to maintain the old SQL Server to store the SMS database, you can rebuild Master.dat (to do this, use the Rebuild Master Database option in SQL Setup on the original SQL Server, selecting a new sort order that does differentiate between the letters V and W). However, before doing so, you should determine whether this SQL Server is in use for other databases as well, because this step will purge all existing databases from Master.dat. If it is being used for other databases, you should carefully evaluate what kind of impact this configuration change may have for these databases. If you come to the conclusion that these databases can be successfully transferred to another temporary SQL Server running on a different sort order, you can pursue rebuilding Master.dat in order to change the running sort order. After completing this step, go through the procedure described in the WORKAROUND section of this article to move the SMS database back to the original server again. Also transfer all other databases you temporarily moved over to another server back to the original SQL server.
Additional query words: prodsms localize Scandinavia resync multi lingual SEM Danish Finnish Norwegian Swedish
Keywords : kbbug1.20
Version : WINNT:1.2
Platform : winnt
Issue type : kbbug
Solution Type : kbpendingLast Reviewed: October 27, 1998