MS-SQL Script Question

[Tim Morrison]

MS-SQL 2000

Is there any way to run a SQL script against MSDE other than with OSQL? (No Enterprise manager or Query Analyzer)

TIA

--
Tim Morrison

--------------------------------------------------------------------------------

Vehicle Web Studio - The easiest way to create and maintain your vehicle related website.

http://www.vehiclewebstudio.com

[oj]

Re: MS-SQL Script Question

You will have to have a client app of some sort (osql/isql/etc). Basically, the
client app will open a connection to your server, parse the content of your
script file into batches delimited by GO, then execute the batches against the
server.

It's quite easy to implement an ado connection to sqlserver, parse the script
file and execute it. QALite on the site does just that.

--
-oj

http://www.rac4sql.net

"Tim Morrison" <sales@kjmsoftw are.com> wrote in message
news:LnnKb.7537 82$Tr4.2103435@ attbi_s03...
MS-SQL 2000

Is there any way to run a SQL script against MSDE other than with OSQL? (No
Enterprise manager or Query Analyzer)

TIA

--
Tim Morrison

--------------------------------------------------------------------------------

Vehicle Web Studio - The easiest way to create and maintain your vehicle related
website.

http://www.vehiclewebstudio.com

[mountain man]

Re: MS-SQL Script Question

The script can be registered as a task and run automatically
without operator intervention.



"Tim Morrison" <sales@kjmsoftw are.com> wrote in message
news:LnnKb.7537 82$Tr4.2103435@ attbi_s03...
MS-SQL 2000

Is there any way to run a SQL script against MSDE other than with OSQL? (No
Enterprise manager or Query Analyzer)

TIA

--
Tim Morrison

----------------------------------------------------------------------------
----

Vehicle Web Studio - The easiest way to create and maintain your vehicle
related website.

http://www.vehiclewebstudio.com