How to Uninstall SQL Compact 3.5 after installing SQL Server 2008

Article ID: 2015126 - View products that this article applies to.
Expand all | Collapse all

Summary

SQL Server Compact 3.5 SP1 can be installed using one of the following methods:
  • As part of SQL Server 2008 installation.
  • As part of installing Visual Studio 2008 or later versions.
  • Downloading it from the Microsoft downloads site.

For further information refer to Installing SQL Server Compact topic in SQL Server 2008 Books Online.

This article describes how to uninstall SQL Server Compact 3.5 SP1 from a machine where the SQL Server Compact functionality is not needed.

More Information

There are two SQL Server Compact related components that gets installed by SQL Server 2008:

  • Microsoft SQL Server Compact runtime (SSCERuntime.msi)
  • Microsoft SQL Server Compact Query tools (SSCESqlWbTools.msi)

You can uninstall both these components using either of the following methods.

  • Use Control Panel’s Add or Remove Programs applet or Programs and Features (in Windows Vista and Windows 7) to remove these programs.
  • Since SQL Server Compact’ MSIs are based on Windows Installer technology you can also use the Msiexec from command line to uninstall these components.

For example, the following command line will uninstall SQL Compact runtime .msi :

 msiexec /x   ssceruntime_enu.msi

You can run msiexec /?   on a command line to see the complete list of options. 

Note: After you uninstall these SQL Server Compact components, you will no longer be able to interact with SQL Server Compact databases from SQL Server Management Studio on that system.

Additional references:  
Note This is a "FAST PUBLISH" article created directly from within the Microsoft support organization. The information contained herein is provided as-is in response to emerging issues. As a result of the speed in making it available, the materials may include typographical errors and may be revised at any time without notice. See Terms of Use for other considerations.

Properties

Article ID: 2015126 - Last Review: February 15, 2010 - Revision: 2.0
APPLIES TO
  • Microsoft SQL Server Compact 3.5
Keywords: 
KB2015126

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com