Monday, February 20, 2012

MS-SQL Script Question

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.comYou 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@.kjmsoftware.com> wrote in message
news:LnnKb.753782$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|||The script can be registered as a task and run automatically
without operator intervention.

"Tim Morrison" <sales@.kjmsoftware.com> wrote in message
news:LnnKb.753782$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

No comments:

Post a Comment