View Single Post

   
  #4 (permalink)  
Old 02-29-2008, 01:55 PM
Jozef
 
Posts: n/a
Default Re: Newbie: How to create a database from script?

Thanks Jens, you ROCK! It worked fine. I know it was a silly problem, but
I couldn't find exactly what I was looking for in the help file.

David, I was just looking for the "tool" to run the script in (and the
additional code that Jens provided to specify the database). The QA was the
answer.

Thanks again!

"Jens" <Jens@sqlserver2005.de> wrote in message
news:1132039143.720269.61390@g49g2000cwa.googlegro ups.com...
> Hi Joseph,
>
>
>
> You have to add something like
>
> USE NameofthedatabaseWhereyouwanttodeploythescript
> GO
> <YourScript>
>
> You can then load this within query analyzer and execute it. if you
> dont have the QA just execute the script with the OSQL commandline
> function like this:
>
> OSQL -S<YourServernameHere> -E -i<PathandNameoftheInputscript>
>
> HTH, Jens Suessmeyer.
>



Reply With Quote