What I would like to do is load a MSSQL script created in Query Analyser
or Enterprise manager onto the server and then run it from CF5.
making and loading the .sql file is easy. Running it is another matter.
I've tried creating a sp which runs xp_cmdshell @st where @st is a
complete osql string. This works but being a 2 stage process it seems
to be difficult to get any meaningful feedback if there is a problem in
the script.
sp_executesql seems to be a better option but how to read the .sql
file?
This must be a common thing people need to do?
--
Regards;
Richard Meredith-Hardy
-------------------------------------------------------------
r[dot]mh[at]flymicro[dot]com
Tel: + 44 (0)1462 834776 FAX: + 44 (0)1462 732668
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
