Transaction timeout on CLR stored procedure

Hi,



I have a CLR stored procedure that times out after approximately the same
duration each time give or take a couple of seconds. It times out at about
the 11 mins, 12 secs mark, which I'm executing directly from SQL Management
Studio. I've not had any issues with timeouts until now, but I've not had a
transaction run this long until now either.



The stored procedure performs a large number of queries, updates, deletes
etc as part of a single transaction. In the transaction options, I've
specified the timeout period to 1 hour as follows:



options.Timeout = New TimeSpan(1, 0, 0)



I have tried setting the Query Wait parameter to both -1 and a ridiculously
large number, with no effect.

I've tried setting the Remote Query timeout to 0 (endless) and another
ridiculously large number, with no effect.



The fact that I'm running this from directly within Server Management Studio
eliminates any restrictions being placed by outside influences such as
ASP.NET



Nothing appears in either the SQL Server logs or event logs.

Interestingly, the transaction seems to get the 'timeout' on the same query
each time. I removed the record that it was crashing on to see if it would
continue, thinking that it may have been maxing out some kind of query
limit. Instead, it failed on the record prior.



Any suggestions on what else may be causing this timeout?