Sql数据库选项设置记录

SQL2008 Tools->Designers->Table and Database Designers=>untick the 'Prevent saving changes that require table re-creation'

SQL2008:Back Up->Options->Set backup compression:Compress backup

 

对于有主外键关系的表注意是否要指定Cascade属性。双击Keys下面的某个外键关系，‘INSERT And UPDATE Specifical’选择 'Cascade'