You can create an entire DB thru a script, at least in SQL Server. We used to do it all the time.

Ask Markus about the data clearing-house they're building - one of the desired options was the ability to transfer a table-modification script to the remote servers to do updates. All of this can be done remotely. Way cool.

>Will that create the stored procedure on the back-end? Or will I have to load this text file every time I wish to execute a certain stored procedure?
>
>>>Hi John,
>>>
>>>OK, now I understand what you're saying, and yes, you've got a huge point. Never quite thought of it that way before. Now then, let me ask you this, because I haven't had the time to try it out: Can I programmatically create these stored procedures somehow? Or will I actually have to show up at a client site? (I hate wearing a suit and tie... <s>)
>>
>>You can create a txt file and send it to the back end as a SPT I belive. If not, the text file can be loaded into SQL Analyzer and run.
>>
>>BOb