You are currently offline, waiting for your internet to reconnect

After you execute the SqlCeEngine.Compact method against a SQL Server Compact 3.5 client database that is synchronized to a central database server, some changes to the client database may not be uploaded

Extended support for SQL Server 2005 ends on April 12, 2016

If you are still running SQL Server 2005 after April 12, 2016, you will no longer receive security updates and technical support. We recommend upgrading to SQL Server 2014 and Azure SQL Database to achieve breakthrough performance, maintain security and compliance, and optimize your data platform infrastructure. Learn more about the options for upgrading from SQL Server 2005 to a supported version here.

RAPID PUBLISHING

RAPID PUBLISHING ARTICLES PROVIDE INFORMATION IN RESPONSE TO EMERGING OR UNIQUE TOPICS, AND MAY BE UPDATED AS NEW INFORMATION BECOMES AVAILABLE.
SYMPTOMS
You have a SQL Server Compact 3.5 client database that is synchronized toa central database server by using Microsoft Synchronization Services for ADO.NET. Then, you execute the SqlCeEngine.Compact method against the database. After you change the client database and perform the synchronization, some changes are not uploaded to the central database server.
WORKAROUND
To work around this problem, use the SqlCeEngine.Shrink method to reclaim space in a SQL Server Compact 3.5 client database.
STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.
MICROSOFT AND/OR ITS RESPECTIVE SUPPLIERS MAKE NO REPRESENTATIONS ABOUT THE SUITABILITY OF THE INFORMATION CONTAINED IN THE DOCUMENTS AND RELATED GRAPHICS PUBLISHED ON THIS WEBSITE FOR ANY PURPOSE. THE DOCUMENTS AND RELATED GRAPHICS PUBLISHED ON THIS WEBSITE COULD INCLUDE TECHNICAL INACCURACIES OR TYPOGRAPHICAL ERRORS. CHANGES ARE PERIODICALLY ADDED TO THE INFORMATION HEREIN. MICROSOFT AND/OR ITS RESPECTIVE SUPPLIERS MAY MAKE IMPROVEMENTS AND/OR CHANGES IN THE PRODUCT(S) AND/OR THE PROGRAM(S) DESCRIBED HEREIN AT ANY TIME.

For more information about the terms of use, visit the following Web site:
http://support.microsoft.com/tou/
Properties

Article ID: 967502 - Last Review: 02/10/2009 02:00:03 - Revision: 1.0

Microsoft SQL Server Compact 3.5

  • kbtshoot kbsurveynew kbexpertiseadvanced kbprb kbrapidpub KB967502
Feedback