Quote:
How to auto create a SQLCE database when one gets FULL
Short answer: You don't.
If you plan to have a database larger than the 4Gb limit, choosing another SQL server without the limit would be a wise choice.
Even if possible, the queries would be extremely complicated and inefficient.