build database from sql script

[Caroline]

I'm new to SQL server and I'm stumped! I have an sql script for a sample
application and need to build the database. I have installed MS sql server
(MSDE) and experimented with generating scripts and playing the scripts,
but I can't figure out how to use them.

Any help would be greatly appreciated.

Thanks

[Eric Echols]

"Caroline" <cjust@io.com> wrote:
>
>I'm new to SQL server and I'm stumped! I have an sql script for a sample
>application and need to build the database. I have installed MS sql server
>(MSDE) and experimented with generating scripts and playing the scripts,
>but I can't figure out how to use them.
>
>Any help would be greatly appreciated.
>
>Thanks

If you are using SQL Enterprise Manager, you should do the following(if you
have the <scriptname>.sql file):

1. Tools Menu--->SQL Query Analyzer
2. CTRL+SHIFT+P to open an explorer window
3. Browse to the <scriptname>.sql file and open
4. F5 to Execute the script

This will create the Database, if there are no errors in the script.

I hope this helps.

[Sreejath S. Warrier]

Caroline,
One way of doing this is to open the script file using a text editor and
selecting the entire text and copy the same into a query analyzer window and
run it. You need to log into the query analyzer window using an account with
DB Creation rights.
HTH,
Sreejath S. Warrier
"Caroline" <cjust@io.com> wrote in message
news:3ea071b0$1@tnews.web.devx.com...
>
> I'm new to SQL server and I'm stumped! I have an sql script for a sample
> application and need to build the database. I have installed MS sql
server
> (MSDE) and experimented with generating scripts and playing the scripts,
> but I can't figure out how to use them.
>
> Any help would be greatly appreciated.
>
> Thanks