Microsoft KB Archive/192474

{|
 * width="100%"|

-

The information in this article applies to:


 * Microsoft Systems Management Server versions 1.2, 2.0

-

SUMMARY
When using SQL Trace to view the queries generated by Systems Management Server to add a new computer to the database, there are many USE DBNAME statements. These apparently redundant statements seem unnecessary because we are only using one database for the computer record.

These statements are required, however, to ensure data integrity because Systems Management Server 2.0 has the ability to add information to multiple databases. The overhead from these statements is minimal.

This effect is by design.

Additional query words: prodsms

Keywords         : smsdatabase smsdataloader Version          : winnt:1.2,2.0 Platform         : winnt Issue type       : kbinfo
 * }