My bet is that the timeout is from a .NET or client application. The default .NET connection timeout is 30 seconds. You can test this by running the same query from Query Analyzer and watching it spin for longer than 30 seconds. That will verify what you are seeing.

You can set the timeout in the .NET 'Command' object. cmd.Timeout = x is the syntax.

Jim