Saving Changes in not permitted. The changes you have made require the following tables to be dropped and re-created...
Menu >> Tools >> Options >> Designers >> Uncheck “Prevent Saving changes that require table re-creation”.
REM: There are local temp tables, global temp tables, and tables in tempdb:
http://stackoverflow.com/questions/2920836/local-and-global-temporary-tables-in-sql-server
SQL Server Enterprise Manager 2000 (or 7) timeout:
In SQL Server 7.0 Enterprise Manager, go to Tools -> Options.... This will open up the dialog box "SQL Server Enterprise Manager properties". Go to "Connection" tab. Specigy the login time-out and query time-out values in seconds. Click OK.
Procedure is the same in SQL Server 2000 Enterprise Manager, only difference being, the "Connection" tab is renamed as "Advanced" tab.
Source: http://vyaskn.tripod.com/sql_server_tools_faq.htm#q7
Syntax for Default Date Value
('2099-12-31') - actually, didn't need to brackets, but MSSSMS adds them after saving.
tags: sqlserver, sqlem,