Willing to distribute an application including SQL Servre Express
I don't if it can be acomplished using scripts or some other thing, please help...
I generally do this by writing my own app that does the installing, and runs silent installs for MSDE, etc. However, I would expect there are merge modules for .NET, if not SQL Express.
Both the .NET Framework 2.0 and SQL Express can be installed by chaining the installation packages into your own application. Exactly how to handle chaining installation packages, that really depends on which installer you are using.
Visual Studio includes the capability to do this with varying degrees of automation depending upon your deployment type, for example, using ClickOnce deployment you can automatically include both .NETFx and SQL Express. If you have questions about the VS Installer, you should be able to find the answers in the VS forums.
As far as configuring remote connections in SQL Express, you can do this using the DISABLENETWORKPROTOCOLS command line switch during installation. SQL Express has a number of command line switches for use during installation, you can find the full list by searching Books Online, which are available through http://msdn2.microsoft.com.
Note, there are no MSMs (merge modules) available for SQL Express.
Regards,
Mike Wachal
SQL Express team