SQL Server seems to be my favourite topic at the moment :-)!
I have written an article for MSDN online, it has gone online this very moment and I am so happy about that. The article is about a generic solution for deploying MSDE with your own solutions using the new MSDE Deployment Toolkit (RC)!
Search MSDN for "MSDE Deployment" and the article is (at the moment :-)) great) the first one in the result list.
Link to the article: MSDE Deployment Toolkit (RC) in Action