CommandTimeout

W

William Ryan

Will you get a timeout exception if the query takes longer than the timeout
period to execute, or does it get thrown when you can't initiate a command
for longer than the period? Or both?

I've tried setting CommandTimeout to 1 and then fire a long running query
and I don't get the exception....so I'm wondering behind the scenes, what
will cause a timeout problem with the Command object?
 
W

William Ryan

Nevermind....I did some research and figured it out on my own. It looks
like if (TotalQueryTime>CommandTimeout ) exceptions are raised.

Sorry about that.

Bill
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Error: Timeout expired. The timeout period elapsed prior to comple 3
SqlCommand.CommandTimeout seems to have no effect 1
Fill method ignoring CommandTimeout value 3
CommandTimeout 4
Transaction and Connection Timeout 2
timeout exception during SqlTransaction.Commit() any workaround please help? 7
Command Timeout on Queries 1
Is it possible to set CommandTimeout at connection level? 6

Top