The biggest downside to using SQL Server Compact Edition is that it does not allow the creation of stored procedures. This seems to be Access with a different name and the same problems. If MS was serious about making this a viable product it should have been able to create stored procedures.