I'm sure you've already tried this, but have you tried executing your query in a SQL Server Query Analyzer window?

Perhaps you can optimize the query so that it doesn't need to time out?