Check http://www.mssqltips.com/tip.asp?tip=1092

>
>Using a Visual FoxPro application, I am looking for a way to install and setup MSSQL automatically.
>
>Up to now I have been using MySQL so far and what I liked there was that I can do the installation and setup directly from VFP without any user intervention. So the user installs the program, and selects the location of the database and port number, and if the location of the database is "localhost" then I install the MySQL database. If the ODBC drivers are missing, I install them also on the fly. I do not want the user to need much database knowledge in order to be able to install our program.
>
>Would this be possible in MSSQL as well?
>
>Thanks in advance for your help.