SQL Script

I have created a SQL database, a user to be used for communications in my
ASP code, my tables, etc. Enterprise Manager gives me a way to create
scripts of the structure. I don't really understand which scripts to create
as their are numerous choices and it will take some more research but I have
a few questions:

1. What is required to have the script create the database, the SQL user and
set their password? I would think it would take an admin account, like SA,
but not sure if that is possible, so I'm asking.
2. Now that I have created the scripts, how can I utilize them on a
different server? I'm assuming using ASP to create the database and the
user is out of the question as these would be needed first to connect. But,
can I run the other scripts, which create the tables and columns, from ASP?

The idea is to make my application portable. I know all I need for the
application but automating the duplication of the SQL structure is my
dilemma.
TIA...

Roland

RE: SQL Script

you may want to look at DB Ghost - http://www.dbghost.com - for a database
change management solution.

"Roland Hall" wrote:

> I have created a SQL database, a user to be used for communications in my
> ASP code, my tables, etc. Enterprise Manager gives me a way to create
> scripts of the structure. I don't really understand which scripts to create
> as their are numerous choices and it will take some more research but I have
> a few questions:
>
> 1. What is required to have the script create the database, the SQL user and
> set their password? I would think it would take an admin account, like SA,
> but not sure if that is possible, so I'm asking.
> 2. Now that I have created the scripts, how can I utilize them on a
> different server? I'm assuming using ASP to create the database and the
> user is out of the question as these would be needed first to connect. But,
> can I run the other scripts, which create the tables and columns, from ASP?
>
> The idea is to make my application portable. I know all I need for the
> application but automating the duplication of the SQL structure is my
> dilemma.
> TIA...
>
> Roland
>
>
>