Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Drop Table Error

Posted on 2007-07-24
6
Medium Priority
?
683 Views
Last Modified: 2008-01-09
I am trying to drop a table in SQL Server Mobile Edition.
I get the following error.
"No Key matching the described characteristics could be found within the current range"

Any idea how I get past this??
0
Comment
Question by:RickJ
  • 4
  • 2
6 Comments
 
LVL 29

Accepted Solution

by:
QPR earned 2000 total points
ID: 19561386
sounds like oledb telling you it can't find the table or the db referenced.
try running a select in the same context from the table you are trying to drop.
0
 
LVL 8

Author Comment

by:RickJ
ID: 19561422
I tried a select and it works fine.
0
 
LVL 8

Author Comment

by:RickJ
ID: 19561580
I have also tried to modify field properties (changing type, deleting) and it comes up with the same error.
If I add a field it works fine and doesnt complain. If I delete the new field it doesnt complain.
Also the table has no data if that makes a difference.

Any more ideas??
0
Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

 
LVL 29

Expert Comment

by:QPR
ID: 19561597
is this table involved in some sort of replication scenario?
0
 
LVL 8

Author Comment

by:RickJ
ID: 19561614
No, replication is not being used.
0
 
LVL 8

Author Comment

by:RickJ
ID: 19563183
I found a solution.
It seems the database was corrupt in some way.
I downloaded and used the "compact" in this tool,
"SQLCE Database Viewer" from www.pocketpctoolkit.com and it worked fine from then on.

Thanks for your help QPR.
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In the first part of this tutorial we will cover the prerequisites for installing SQL Server vNext on Linux.
This shares a stored procedure to retrieve permissions for a given user on the current database or across all databases on a server.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Via a live example, show how to setup several different housekeeping processes for a SQL Server.
Suggested Courses

578 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question