Changing the CommandTimeout in SQL Management studio
If you are getting a timeout while on the table designer, change the “Transaction time-out after” value under Tools –> Options –> Designers –> Table and Database Designers This will get rid of this message: “Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.”