VC Language - Help regarding executing Sql script

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Help regarding executing Sql script

Usman

2006-05-29, 8:11 am

Hi

Has anyone used ISql tool that comes with the windows installation. I'm
trying to run an SQL script using it giving the command

iSql -U user -P password -S server -d Database -i <path to sql script file>

What happens is that it does start executing the script but takes so much
time if the script contains around 100-200 statements. When I execute the
same script using MS SqlServer Managment studio, it executes it all within
2-4 seconds. Is there any way to speed up the process using ISql tool, like
if i'm missing any argument or something. Or if there's any alternative
method to do so. Actually I've to do so from my VC++ code so looking for any
alternative method possible.

Regards

Usman

Sponsored Links