Redistributing a SQL application

[CryoEnix]

I have an application that connects to a local SQL server (2005) for all of its data access. Now, when the completed application is installed on a new computer the SQL database needs to be installed too - the DB layout at least - all data to be blank but I need all of the tables & stored procs etc to be installed.

Now would a full version of SQL server need to be installed on each machine for this, or is there an easier way to redistribute a database shell like this? I remember installing something a year or so ago that auto-installed a mini sql server with it. Any ideas?

Thanks in advance

 

[PlausiblyDamp]

Have you considered SQLExpress?

 

[CryoEnix]

Il be honest with you plausibly, Ive never heard of it. Ill some quick research now - thanks!