• Yes, there are no stored procedures and views.

    Steve Lasker, Program Manager of SQL Server Everywhere has an answer to this question in his blog...(http://blogs.msdn.com/stevelasker/archive/2007/05/14/empowering-your-users-with-reference-data-and-knowledge.aspx)

    He says "We continually hear from customers they must have stored procedures in SQLce, or it's just not a real database.  Aside from us not wanting to expand the size of the nice compact database engine, or the code free file format, I'd ask, do you really have everything you need locally to run the exact sproc locally?  Do you really want to burden the local machine with everything the server needs to complete the operation? .............(Read further from his blog)"

     

    .