In most of the cases I handle this type of situation from the client.
If you use ADO connection to connect to the database It has a Commandtimeout property
You can set the time there
Preethi
Cheers,
Prithiviraj Kulasingham
http://preethiviraj.blogspot.com/