Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

MS SQL Server Management Studio 2010 seems not support compact databases (add/remove records).

Is there any utility? Free one would be nice.

share|improve this question
Do you mean something to graphically view and edit tables? Per my answer, SQL Server Management Studio does support adding and removing rows in SQL CE tables through the use of T-SQL Queries. Maybe modify your question if this was your intent? – Greg Jackson Jun 23 '11 at 8:12
up vote 2 down vote accepted

It looks like SQL Server Management Studio does, indeed, support SQL Server Compact. However, depending on where you're actually hosting the instance from, the best tool might be something different.

If you're looking for a graphical tool (to view the tables, instead of using T-SQL queries), I found this list of SQL Server Compact tools. CEQuery looks particularly promising, and it's on CodePlex, so it's completely free.

share|improve this answer
I tried CEQuery but it crashes. SQL Server Management Studio doesn't support Edit Top 200 Rows either. I don't need to design DB tables, I need to insert/delete records in a grid interface. – Nime Cloud Jun 23 '11 at 9:00
I use SDF Viewer. – Nime Cloud Jun 23 '11 at 11:57
I didn't try any of them out; I don't use SQL CE because of a different set of limitations (no server-generated keys). Glad you found something that worked. The list I linked has a lot of similar ones listed, so if you continue to have problems you still have more options. – Greg Jackson Jun 23 '11 at 16:16

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .