MSDE scripts

#1

If I have a script to create a database and all the tables etc. How can I
run that script in MSDE to create the database etc. from a command Prompt?

Thanks.

#2

look up osql in Books Online

--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.allisonmitchell.com - Expert SQL Server Consultancy.
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

"Ed Willis" <ed_willis (AT) acsi (DOT) orgnospam> wrote

Quote:

If I have a script to create a database and all the tables etc. How can I
run that script in MSDE to create the database etc. from a command Prompt?

Thanks.

#3

Does anyone have a sample command line prompt that will execute osql and run
a SQL script?

"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote

Quote:

look up osql in Books Online

--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.allisonmitchell.com - Expert SQL Server Consultancy.
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

"Ed Willis" <ed_willis (AT) acsi (DOT) orgnospam> wrote in message
news:%231VIfyk9DHA.2316 (AT) TK2MSFTNGP11 (DOT) phx.gbl...
If I have a script to create a database and all the tables etc. How can
I
run that script in MSDE to create the database etc. from a command
Prompt?

Thanks.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

MSDE scripts

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

MSDE scripts - 02-18-2004 , 12:25 PM

Re: MSDE scripts - 02-18-2004 , 12:47 PM

Re: MSDE scripts - 02-18-2004 , 01:02 PM