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