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.