i need to put 100 000 into my sql ce server database
sqlcecommand.commandtext("insert into table_abr (abrabr) values(abrabr)")
takes ~ 2 hours
what could you recomend to do

Hy all,
here's another problem for you ;)
Take a look to the code below:
public List<Item> ItemSeleziona(Item item)

I have just installed the official sql Compact Edition and I find I cannot
edit any of the fields in a database that was created in the pre-release
version using SQL Server 2005. I get the message:
Internal Error DDL Operations are not allowed on System Tables [Table

Hy all,
look at this code:
string connectionString = "Data Source=D:\\Visual Studio
2005\\Projects\\myProject\\myProject\\myProject.sdf;Persist Security

Thanks for your previous help on this group.
I have a new problem: I do a "select col1, col2, col3 from T1 inner join T2
on ... " where col3 is a BLOB column;
If I use cmd.GetValue(1) I get a pointer to data of col1, GetValue(2) gives

Is it possible to use SQL 2005 Compact Edition and Visual Studio 8
without Service Pack 1?
I have installed the SDK with put the System.Data.SqlServerCe.dll in
C:\Program Files\Microsoft SQL Compact Edition\v3.1\. All references

The new release only talks about the desktop verison. so I wonder how can I
install it on the device?
(I prefer not to do it with VS, as I need to deploy it on several devices.)
tia,

Now that SQL Sercer 2005 CE is RTW, what are our deployment options? Do we
have to provide/link to the runtime MSI as a separate installation? Or is
there a merge module that we can incorporate into our application installer
projects? Thanks

Hi, is it posible to create a new database on SQL Server 2005 Compact
Edition using the SQL Server 2005 Managament Studio Express?

I am re-posting my question and attempting to make it a little more clear my
problem. I appreciate any help.
I have installed the following Microsoft SQL Server 2005 Compact Edition
files: (Released 11 Jan 2007)

I have an IPAQ 3835 with Windows ce 3 o/s.  Can this be upgraded to ce 5 or
ce 5 emulator?  If so, how?  I'd like to run sqlserver mobile or compact on
my IPAQ, but don't you need at least ce 5 to do that?   Thanks.

Does SQL Server 2005 Compact Edition include the query analyzer like the
older versions did?  I actually use it quite a bit for writing SQL code
while on the road.
Thanks

I have installed the the following Microsoft SQL Server 2005 Compact Edition
files: (Released 11 Jan 2007)
Microsoft SQL Server 2005 Compact Edition Server Tools.msi
Microsoft SQL Server 2005 Compact Edition Developer Software Development

Ginny,
Really not meaning to be a Pita here, but my
Microsoft SQL Server Compact Edition directory only has a v.3.1 directory
and then Docs and SDK subdirectories under that.

Please note that  my MS SQL database contains arabic data, I can
transfer it easily to my pocket pc and browse it on my SQL CE database.
But when I'm printing this data it is appearing "??????" question
marks. As if it doesn't understand these words.