SQL Server Timeout Expired on Redesign of Table with many rows
07-Aug-0909 Leave a comment
Go to SSMS > Tools > Options > Designers > Table and Database Designers >
and change Transaction Timout After from default of 30 seconds to something larger.
May well also be necessary to temporarily increase the log file size. Then return it back to it’s previous size