TransactionScope/SqlTransaction timeout extension

Question

Is it possible to extend the timeout of a transaction (with SQL Server) once the transaction has started?

Not AFAIK... and in many cases it would be up to DTC, not the SQL Server. — Marc Gravell, Jan 18 '11 at 12:30

gbn · Accepted Answer · 2011-01-22T14:52:30.880

2

The timeout is "external" to SQL Server, so SQL Server can not affect it.

So "no" unfortunately

edited Jan 22 '11 at 14:52

answered Jan 18 '11 at 12:19

gbn

Just out of interest, in what way is it external? When I said "with SQL Server" I meant that is the database I'm using, not that the transaction needed to be extended using SQL. – enashnash Jan 23 '11 at 20:40
Ah, I mean that the timeout is set by the caller or msdtc, and is not known to SQL Server – gbn Jan 23 '11 at 20:59

score 0 · Answer 2 · answered Jan 19 '11 at 20:39

0

I doubt it, but you could rollback and retry.

answered Jan 19 '11 at 20:39

Beth

2 Answers2