I wish you the very best of lucks And good work.

Keep posting

My best regards.

I also use the .NET Compact Framework and yes, it is very far from the full one. It is understandable why this has...

Well, has I've said before, you won't be able to do that sort of things using the sqlserverce engine! This is, in that sort of operations you should consider the...

Hi there.

Well... I got to say one thing. In fact SqlServerCE isn't in any way a common database engine. It only performs simple tasks - the versions I've tried were...

I believe the best way to do that is to really detach the db and copy it. This way you'll have a clean(unreferenced) database file with wich you can do...

Well, I've tried the creation and selection procedures you've mentioned and everything worked just fine. Didn't get any problem - should work just fine, either one of them - probably...

Well. Sometimes when you uninstall some MSDE intance the actual MSDE engine remains installed on the machine. Also, and most of the times i've tried, the database and log files...

I agree with Chris You should always keep everything as distinct as possible. One server for SQL2000(only), doesn't need anything more, and the...

Always keep in mind that SqlServerCE isn't a true SQLServer! This is, it doesn't support most of the tsql query you're used to probably - including the inner joins from...

That developer stuff is unreal ... You should know better! That's why I like to do all on my own - never had a db problem nor a DBA to...

Humm ...

Is this in .NET ? If so why don't you use the Oracle Provider by Oracle ... I believe you can find it's download somewhere in their web site!

I...

! I'm not sure if this will work but, give it a try if you want to

Try and change your connection string to...

My PK is clustered and it is the only index in the table. The command I have been using is the most simple command. Notice that I'm running these...

No. Just the Primary Key, being the aggregation of the 3 indexes, produce a distinct value. The individual columns produce rows in the amount specified in the first post.

From the experiences I have...

This may look simple - and it is - but try and use this kind of script :

"SELECT TOP 10 FROM Product WHERE ProductID NOT IN (SELECT TOP 10 FROM Product...