Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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
add comment

1 Answer 1

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
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.