Comments by vb_buddy (Top 4 by date)

U are true... this might not solve the problem...
I will explain you the process of transaction :

The software runs on VB.net
-> the user clicks on the save button
-> it goes to a function and gives all the data viz.. name of the stored procedure, columns names, raw data through command.Parameters.AddWithValue
and than the whole set of queries is executed in the stored procedure.
And than it again comes back to vb.net and takes the result. In case if anything goes wrong in between, the entire transaction is rolled back and throws an error through VB.Net.

My idea is if this whole set of transaction takes more than a specified amount of time, it should not be executed and should throw an error to the user. And than the user has to again process the transaction.

I have a gut feeling that you will solve my problem.

Warm Regards..

Thank you... will try

Thank you all for your valuable time for my query.
Can we put timeout value for queries in stored procedure.
say 10 seconds, and if it crosses the time, the entire transaction is rolled back.

Thanks in advance