RE: compacting sql ce database loses records

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Brad Syputa - MS (bradsy_at_Online.Microsoft.com)
Date: 05/24/04 

Date: Mon, 24 May 2004 15:57:41 GMT

Hi Paul,

If you are losing records, this would be a bug. Contact Microsoft PSS. If
it really is determined to be a bug, which losing records is, you will be
refunded any fee's.

--------------------
| From: pstrauss@pacbell.net (Paul Strauss)
| Newsgroups: microsoft.public.sqlserver.ce
| Subject: compacting sql ce database loses records
| Date: 22 May 2004 17:18:48 -0700
| Organization: http://groups.google.com
| Lines: 7
| Message-ID: <353fe9d9.0405221618.45fb0809@posting.google.com>
| NNTP-Posting-Host: 64.161.70.35
| Content-Type: text/plain; charset=ISO-8859-1
| Content-Transfer-Encoding: 8bit
| X-Trace: posting.google.com 1085271529 30852 127.0.0.1 (23 May 2004
00:18:49 GMT)
| X-Complaints-To: groups-abuse@google.com
| NNTP-Posting-Date: Sun, 23 May 2004 00:18:49 +0000 (UTC)
| Path:
cpmsftngxa10.phx.gbl!TK2MSFTFEED01.phx.gbl!TK2MSFTNGP08.phx.gbl!newsfeed00.s
ul.t-online.de!t-online.de!news.glorb.com!postnews1.google.com!not-for-mail
| Xref: cpmsftngxa10.phx.gbl microsoft.public.sqlserver.ce:12455
| X-Tomcat-NG: microsoft.public.sqlserver.ce
|
| We are trying to compact a 7.42 meg database on the handheld and
| notice that we have loss of rows of data after the process. We are
| trying to track the available memory and adjusting the ratio between
| storage and program. Any ideas why this is happening? Is it related to
| the memory issue
|
| Paul
|

Relevant Pages