Viv,

I think I can get around these limitations for an eval version of our software. Are you using it? I was just looking for any tips on getting started and making a connection. Do you know if you have to port your SQL data (.mdf) to the compact format (.sdf)?

Thanks,

Mat

>Hi,
>
>>In my working with it, I have discovered a few things that would preclude it being used on the desktop:
>
>I think that depends on the application.....
>
>>1. Slow
>>2. No stored procs
>More limiting - no Views or triggers either
>
>>3. No cte's
>>4. No batch queries
>>5. No support for spaces in names, etc.
>>6. Limited designer support
>
>>7. No Transaction support
>Advertised as supporting simple but not distributed transactions
>
>>8. No Multiple connection support
>256 concurrent connections ?
>
>Also limited to one database.
>On the upside the footprint is minuscule compared with SQL Express and it can be deployed just by including the relevant .NET Dlls with the app.