Solid Edge How to Delete Standard Parts Databases

This article instructs you how to delete a Standard Parts database without the need to remove or reinstall software.  You might want to delete a database if it is obsolete, has been created by fault, or it is broken.

Important: Make sure to have a backup of the Solid Edge Standard Parts folder before proceeding. With this backup it is safe to delete a Standard Parts database because all the necessary information to build a new database is in the parts themselves.

As suggested in Chapter 1 of the Standard Parts Installation Guide, for the SQL Server administration, you can download and install the latest Microsoft SQL server management studio (SSMS). In the SSMS you expand the node 'Databases' and right mouse click on xCP_localGUIdb95 and all the databases with the prefix xsmp95 and delete them, if you want to delete all databases. In my example I only delete 'ForAllUsers', hence I do not delete xCP_localGUIdb95 but only xsmp95_ForAllUsers.

When you are finished do not forget to restart the SQL server.

You can proof the deletion and look for those databases on disk in the folder

C:\Program Files\Microsoft SQL Server\MSSQL14.MSSQLSERVER\MSSQL\DATA and delete them if they are still there.

In my example I only deleted the database called 'ForAllUsers', hence the other databases are still existent and *ForAllUsers*.mdf and *ForAllUsers*.ldf are deleted as expected.

Solid Edge Standard Parts FAQ collection