I have an add on app that is almost ready for distribution. I am trying to use Visual Studio Installer 1.1 to install the app and create a small database on MS SQL Server 2000.

The SQL Server 2000 client already exists on the target and we want to be able to run some sort of script or small app to create the database and tables.

I have been unable to find any sort of information on how to accomplish this. Can some some briefly explain the steps needed and/or point me to some useful information. Any help will be greatly appriciated.