Page 1 of 1

Batch Execute SQL Script with Progress

Posted: Mon 07 Feb 2005 18:53
by Mimar
Hello,

I want to batch execute a SQL script prepared by a user on the target system. During execution I want to display progress (execution percentage of script) and also allow a choice of aborting/continuing execution.

How can I do this with SDAC?
Sinan

Posted: Tue 08 Feb 2005 16:16
by Ikar
For MS SQL it is a quite difficult task as scripts are passed to the server by single block. Try to use MSConnection.OnInfoMessage, but it may solve the problem only for some particular cases.