Deploying database with application

i written an application in vs2005 using vb; it connects to a database on the server.

how do i publish/distribute this application with the database? so that when the client installs the application it will also create the whole database on its machine... or have it create the database on a server asking the client to specify the server path, name... etc

i am sure there is a simple way ot do this but i am new ot this and have never done this before..

appreciate all the help... thanks

You can take help of unattended installation, refer http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=636755&SiteID=1 too.|||

Here is an excellent resource detailing unattended installations of SQL Server along with applications.

SQL Server 2005 UnAttended Installations
http://www.devx.com/dbzone/Article/31648