New Empty database

i would like to know how to create a new instance of sql server. i am
using a program that i have to duplicate the database while it is
blank/emply and be able to connect to either database from
workstations. i dont know if i am using the correct terms but that is
what i need to accomplish, any help would be appreciated
Craig
you can create a database like this "create database test"
You can issue this command through ADO, or isql in a batch file.
You can also use SQLDMO for this:
set objServer = CreateObject("SQLDMO.SQLServer")
set objDatabase=CreateObject("SQLDMO.Database")
objServer.Connect "hilary2kp", "sa","se1cure#"
set objDatabases=objServer.Databases
objDatabase.Name="test123"
objDatabases.Add objDatabase
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"tcicraig" <craig@.tcicomputer.com> wrote in message
news:de60a738.0410272107.576c7432@.posting.google.c om...
> i would like to know how to create a new instance of sql server. i am
> using a program that i have to duplicate the database while it is
> blank/emply and be able to connect to either database from
> workstations. i dont know if i am using the correct terms but that is
> what i need to accomplish, any help would be appreciated
> Craig