Timeout problem HELP

[Capt_Ron]

I have a Stored Procedure that restores a database. It works fine with smaller database but tiems out when use on larger (2GB) databases.
How can I extend the timeout period?

Thanks
Ron