Posted by Jozef on 11/16/05 09:37

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.googlegroups.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.
>

• Next in forum: Re: flexible back-end data handling in .net + sql project
• Prev in forum: Re: flexible back-end data handling in .net + sql project
• Thread view: Re: Newbie: How to create a database from script?

[Reply to this message]