Error:
Failed to open malformed assembly ‘mscorlib’ with HRESULT 0×80070008.

If you are sure your SQL query is correct trying having your webhost restart the SQL server engine. This error could mean the SQL process does not have enough memory to process your request..

other error:
There is insufficient system memory in resource pool to run this query.

We found some article relating to the DTS Wizard which is a good tool to use for exporting and importing db structures.

so far we have not found the toolkit for SQL 2008 and assume the 2005 version works with 2008. If you have confirmed this please feel free to contact me and correct this information.

You can download the DTS Tool via the 2005 toolkit which can be downloaded from Microsoft.

Additional information
Microsoft Connect

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

Try adding a Connect Timeout in the web.config

The Connect Timeout attribute of a connection string determines how long a SqlConnection Object runs before it stops attempting to connect to a server.

Reference

You can view the current connections by executing the system proc
sp_who2 , if you wish to kill the connection type: kill and the pid number

or use

ALTER DATABASE ‘DATABASE_NAME’ SET SINGLE_USER WITH ROLLBACK_IMMEDIATE.

OMG :

Error :
The Save (Not Permitted) dialog box warns you that saving changes is not permitted because the changes you have made require the listed tables to be dropped and re-created.

The following actions might require a table to be re-created:

Adding a new column to the middle of the table
Dropping a column
Changing column nullability
Changing the order of the columns
Changing the data type of a column

Reference: MSDN

The user posted a good point on M$ website. what are you suppose to do with the data once the column has been dropped.

Answer: export the data out and back in duh…. But this is a stupid security setting.. bad Microsoft….

***updated information ********
no words can explain how I am feeling right now .
******************************
Solution:
Within studio management 2008 , you will need to click on tools > options > designers tab > uncheck prevent saving changes that require table re-creation
****************************
Thanks to Henry Cordes for finding this
Henry Cordes