Hi - thanks for your reply. I didn't think it was possible either but sometimes you have to ask a wider audience.

Thanks for the info.

I ran a backup and restore to another area and ran the DBCC CHECKDB command and it came back successfully with no errors. I guess this...

"parameter sniffing at work"

I saw this within another thread 2 below this one. Defined local variables as discussed and it seems to have dome the trick! The execution...

The .asp page is located on the same server as the database but takes only 20secs when run locally on the server and from a users PC.

The Query Analyser is...