Compact Database Error Code: 0

Hot Topic

Embedding/Distributing SQL Express With A VB Program
Class does not support aggregation
An easy way to reference the nth row from a table meeting a condition x, and the mth row from the same table meeting condition y
Client Printing Hangs
Metadata Issues
SSAS 2005 on Windows XP?
horizontal ordering of column names
Full Text Search Engine in Chinese Simplied
SSIS Script component for data conversion
xml to relational tables

SQL Server

SQL Server error '80040e14' (The server encountered a stack overflow during compile time. )
vs 2005 august ctp with sql express
Creating a double entry book keeping system
Import an mdb file
DataRecordTypeToBufferType not declared
One-to-many query, returns double rows
Setting cell properties in a scope
How To Avoid Table Scan
client redirect
Release database lock

Compact Database Error Code: 0

I am currently working in VB.NET with SQL Mobile 2005.  I am trying to compact a database, .sdf, using the SqlCeEngine Object compact(connectionstring).  When I use this code to compact a small database, only about 300KB, it returns okay however when I try to compact a larger database, about 9MB, it returns with a SQL Error Code: 0, "The operation completed successfully" however with no compacted database.  The code works however it only seems to work for smaller databases.  Does anyone have any ideas on how to correct this error or tell me why it returns with that type of error.

Snuggs

Answer this question

Compact Database Error Code: 0

  • han33981

    Yes actual copy of the database itself. Before sharing it to me, can you check whether the DB is in correct state. compact.exe /verify would let you know if there any bad pages in the DB.

    Thanks,

    Laxmi NRO, MSFT, SQL Mobile, Microsoft Corporation



  • CarineY

    Please send it to l-a-x-m-i-n-r-o-A-T-m-i-c-r-o-s-o-f-t-D-O-T-c-o-m Please also paste this question link in the mail for the context. Thanks, Laxmi NRO, MSFT, SQL Mobile, Microsoft Corporation

  • MattiV

    Hi Snuggs,

    As per our conversation I could see that you have opened a bug here in Product Feedback center. http://lab.msdn.microsoft.com/ProductFeedback/viewFeedback.aspx feedbackid=d0f14331-1b05-418a-9a11-2378457e4eb8

    And as mentioned we could not repro. We are able to compact the DB very easily with a sample C# program mentioned in the above URL.

    Thanks,

    Laxmi NRO, MSFT, SQL Mobile, Microsoft Corporation



  • dtrade

    The DB is in the correct state. Do you have a direct email address that I can send this to you because this will not let me send this as an attachment.

  • James Y

    What do I need to do in order to give you the repro, do you mean just an actual copy of the database itself or something else

  • H_H_2006

    I am able to compact the database of size nearly 21 MB in our lab.  Is it possible for you to share the repro for us to diagnose. 

    Thanks,

    LaxmI NRO, MSFT, SQL Mobile, Microsoft Corporation



  • Compact Database Error Code: 0
Answer this question