After further investigation, the problem seems to occur once the web application has called the relevant functions.

There are two functions, one selects the data to display and the other updates...

As stated, when I try and run a simple update query from Query Analyzer it times out too.

I am not trying to execute a SQL statement that I build on...