Error: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. The statement has been terminated.

In Management Studio, Tools -> Options...-> Desigers tab, change "Transaction time-out after" to the number of second that you want. In the following example I've modify it to 3 minutes: