Hi

Thanks for your detailed reply...

For all the SELECT queries I changed with nolock, i can see visible difference on the page loads.

Aslo found that SQL 2000 SP3 not installed and...

This error happening not in particular sql call (most of the time it occurs on Insert statements)...  I added more error trapping script in my asp as well sql profiler on...

Its happening random...  This timeout error happens at SQL Server level or ASP script level?