Any fix to SQL Server Management Studio timing out when Adding a New Column to a Table

A while back I posted the inquiry http://nullpointer.ph/questions/3204/any-fix-to-sql-server-management-studio-timing-out-when-adding-a-new-column-to-a-table

Thanks to Alistair sharing his knowledge. After some research got the following fix

that is, navigating Tools > Options then looking at Designers > Table and Database Designers node you will have Table Options. Override the default value of Transaction time-out after: [____] seconds with your desired length of time.

How to Install SQL Server Management Studio 2008 Express Edition

Frustrating as it is, SQL Server Management Studio 2008 Express is NOT part of the "normal" SQL Server 2008 express installation.

How then it could get installed?
Download SQLManagementStudio_x86_ENU.exe here http://www.microsoft.com/downloads/details.aspx?FamilyID=08e52ac2-1d62-45f6-9a4a-4b76a8564a2b

Run it and wait until the below is displayed


Select the "New SQL Server stand-alone installation..." link option. Follow the usual installtion but upon reaching the below dialog box, select the "Perform a new isntallation of SQL Server 2008" option.


When you reach the "Feature Selection" dialog, check the "Management Tools - Basic" option.


Continue the installation process and once complete SQL Server Management Studio will be foound in your Program Files list.



Simple eh?