>Hi all,
>
>I want to be able to:
>- Deliver my apps without the database
>- When running, it will check the existance of SQL Server instance, if not
>exist, ask the user to Create the database and save user authorization in a
>configuration file (local-encrypted-free dbf).
>- While connecting to the SQL Server for the first time, my apps would ask
>the password to connect to the server. The password to access the database
>should be created with my apps created randomly and saved in the
>configuration file. Hence, only the apps itself knows the password (and me
>as the vendor of course!). This means nobody (even if he/she has access to
>SQL Server) can view or access the database.

Any user that has System Administartor role granted can view or access any DB.

>- If the SQL Server already exists, open the database using available user
>authorization stored in the configuration file.
>
>Question:
>1. Is there any facility in SQL Server that mimics VFP's GenDBC? I want to
>create the database with the Enterprise Manager (its faster and easier) and
>then create a code to recreate the database that can be called from my apps.

You can do that in Enterprise Manager (EM) by right clicking on DB and selecting All Tasks - Generate Sql Script. You can also do it programmaticaly with SQL-DMO using Script method of different objects. The ExecuteImmediate method of SQL Server object can be used to to run the script on the target server.

>2. Anybody has ever implement this before? (of course!). Can you please
>share your experiences?
>
>Thanks in advance!
>Willianto
>P.S. This is a cross-post. I've posted this messages several days ago in microsoft.public.fox.programmer.exchange - but there was no satisfying answer; well, in fact there was only one reply. I hope this is alright with UT community.