How to Delete Temporary Tables from the MSCS_CatalogScratch Database
The CatalogCleanup.vbs script is a tool that you can use to delete temporary tables from the MSCS_CatalogScratch database. This tool does not delete the CTLG_PropertyTableMap table.
To improve run-time performance, the Catalog System uses the MSCS_CatalogScratch database to store temporary catalog tables. These temporary tables are empty when they are not being used. We recommend that you run the CatalogCleanup.vbs script weekly to remove the tables. If you do not run the script, the temporary tables will remain in the MSCS_CatalogScratch database.
The CatalogCleanup.vbs script is located in the %Commerce_Server_Root%\Tools folder.
Note
Use the CatalogCleanup.vbs script when your Commerce site is not running to prevent performance impact and to make sure that all temporary tables are deleted. If you use the script while a Commerce site is running, the temporary tables that are used by the open SQL connections will not be deleted.
To run the CatalogCleanup.vbs script
At the command prompt, type
CatalogCleanup.vbs "<Catalog database connection string>"
To find the Catalog database connection string, open Commerce Server Manager and expand Commerce Sites, expand your site, expand Site Resources, right-click Product Catalog, and then click Properties. In the Product Catalog Properties dialog box, on the Connection Strings tab, use the value in the Value of selected connection string text box.
Press Enter.
In the dialog box informing you that the operation completed successfully, click OK.
See Also
Other Resources
MSCS_CatalogScratch Database Tables
Catalog System Database Tables