Urgent SqlServer 7.0 db doubt

[sams73]

I have done a small project with vb6 as front end and sqlserver7 as backend.it's a prj that generates report reading the proxy server.As the users r heavy the database is heavy and when the exe is run first time to select the users(populated tp combo) after selecting a date from datepicker generates a timeout expired error and exits and when the same exe is run and same date is selected the user list is obtained fast(as i'm writing the already selected date userlist into a textfile,which i thought would be fast the next time the same date is selected.),i tried indexing the table but still it returns the timeout expired.
Can anyone help me in this regard with a suggestion to resolve this issue.i"m a novice as far as Db is concerned and expecting soemone's help in this regard.

 

[christheprogrammer]

I hope this helps:
Go to Enterprise Manager, Select your Server, and Goto Query Analyzer. Now type in this (Put a larger number in for the 100):

sp_configure 'resource timeout', 100
now erase it and type in this:
RECONFIGURE with override
now stop the server and restart it.
Check sp_configure on books online for more help

Cheers
Chris

 

[sams73]

Thanx for listening, i will try out the solution provided by u,but can anyone provide me with alternative solution incase this fails,as i'm in need of solution so urgently.i will be grateful if more solution is provided,i strongly believe there is more than one solution to a problem.