Microsoft KB Archive Search

Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

  1. Home
  2. [SDP 2][9EDB5129-098B-4784-9116-A0F5BEFE4903] Microsoft Dynamics RMS Store Operations SQL Baseline Information Collector

[SDP 2][9EDB5129-098B-4784-9116-A0F5BEFE4903] Microsoft Dynamics RMS Store Operations SQL Baseline Information Collector

Summary

The Microsoft Dynamics Retail Management System (RMS) Store Operations SQL Baseline Information Collector collects information that is used in troubleshooting Store Operations database issues.

↑ Back to the top

More Information

This article describes the information that is collected from a computer when you the Microsoft Dynamics RMS Store Operations SQL Baseline Information Collector.

Information that is collected

Number of stores
Description
File name
Count the number of stores in the database
Store.csv

Accounting information
Description
File name
Collection of accounting data that is stored in the Accounting table
Accounting.csv

Configuration

Description
File name
Collection of store-configuration information from the database
Configuration.csv

Items

Description
File name
Collection of items in the database
Items.csv

Duplicate customers

Description
File name
Collection of duplicate customers in the database
Duplicate Customers.csv

Duplicate items

Description
File name
Collection of duplicate items in the database
Duplicate Items.csv

Duplicate batches

Description
File name
Collection of duplicate batches in the database
Duplicate Batches.csv

DB schema

Description
File name
Collection of the database schema
DB Schema.csv

DB triggers

Description
File name
Collection of all the database triggers
DB Triggers.csv

More information

  • We recommend that you run the diagnostic from the computer that is experiencing the problem or from the computer for which you want to represent the environment for your question.
  • The diagnostic may be run from multiple computers if you believe that they are involved with the issue and if you want to send additional information that may help resolve the issue. Each computer on which the diagnostic is run will provide more information for the support professional. It is helpful to run the diagnostic against both the client computer and the server to provide complete information.
  • We recommend that you run the diagnostic by using credentials sufficient to query the instance of SQL Server to let more-detailed version and setup information be collected. If you do not want to collect information from the SQL Server environment, click Cancel when you are prompted for SQL Server connection information. Data from the local computer will still be collected.
  • Currently, the troubleshooter reads database values from the current Store Operations database within the Microsoft Dynamics RMS Store Operations installation to determine whether the data within the tables is correct or needs correction.
  • This information is collected only if the diagnostic is run on one of the following operating systems:
    • Windows Vista
    • Windows XP
    • Windows Server 2003

References

For more information about the Microsoft Support Diagnostic Tool (MSDT), click the following article number to view the article in the Microsoft Knowledge Base:
926079 Frequently asked questions about the Microsoft Support Diagnostic Tool (MSDT)

↑ Back to the top

Keywords: kbmbspartner, kbmbsmigrate, kbsurveynew, kb

↑ Back to the top

Article Info
Article ID : 2460993
Revision : 1
Created on : 1/7/2017
Published on : 10/31/2011
Exists online : False
Views : 114