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.
- 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.
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.