Forum Replies Created

Viewing 15 posts - 1 through 15 (of 19 total)

  • RE: SqlServerCE - Two connections to database

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

    Keep posting

    My best regards.

  • RE: SqlServerCE - Two connections to database

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

  • RE: SqlServerCE - Two connections to database

    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...

  • RE: SqlServerCE - Two connections to database

    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...

  • RE: Making a copy of mdf and ldf

    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...

  • RE: very weird SELECT error (MSDE)

    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...

  • RE: Cannot reinstall MSDE on XP after uninstalled

    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...

  • RE: SQL 2000 and dot.NET

    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...

  • RE: SQL CE

    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...

  • RE: Suspect Database - Need Help!!

    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...

  • RE: Using 4 part names against Oracle Linked Server

    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...

  • RE: PDA connect to SERVER DB problem

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

    Try and change your connection string to...

  • RE: SQL Performance Issue

    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...

  • RE: SQL Performance Issue

    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...

  • RE: PAGING? Is there something similar to MYSQL "LIMIT"

    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...

Viewing 15 posts - 1 through 15 (of 19 total)