Hi All,

Once again i am in a problem. Is there any method to execute heavy sql queries without helding the application. I explain:

Frontend = VB6
Backend = MS SQL Server2000
I have lot of sql queries (of insert and update) in my vb application, which takes 3 to 4 hours to complete on the query analyzer. If I execute same queries from my vb aplication, the application held untill the query complete. I know that the execute command from VB waits for the response of executed command. But do You know any solution that the user of application can use application while he also execute any sql for a long time.

Logically I am thinking that it can be done if I added all my execution plan in my different vb exe files, and execute the concern exe (through shell command), so the concern exe will execute the sql and my main application will be smoothly on the way. is it posible or do you have better idea. and also if it is possible, then how can i send parameters from my main application to concern exe to execute the sql.

Thanks in advance for the solution.

Umar