help for sql server 2000

[randeep 0]

hello all

i am preparing a utility to execute sql server 2000 (osql) scripts. now the problem is how to get the output of the osql scripts. i know i can take it by using '-o' in between the commands to run, but this will take output to a text file only. how i'll know whether the script is executed perfectly or not???????

[Zedna 172]

You can run SQL commands including SELECT also through ADO

There are many examples on the forum.

Search for: ObjCreate ("ADODB.Connection")