Tuesday, February 14, 2012

database corrupt , I want delete some table

I have database currupt some table , I want to delete / drop table

Example

1. databaseTest Have --> table customer , table payment , table sales

2. table Payment can't select / drop / insert /rename (fail) show message error below

ERROR (Row 0);
Microsoft SQL Server 2000 Windows CE Edition:
"The database file is corrupted. (Database name: "" )"

3.How to drop table Payment (I want to drop and create table again and insert data to new table ) Or How to solution for repare table Payment

Thank You

Suwimol

You can try to recover the database file by using SqlCeEngine.Repair method or the native equivalent.

Reference: http://msdn2.microsoft.com/en-us/library/ms172411.aspx

Thanks

Pragya

No comments:

Post a Comment