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'

posted on 2012-01-30 09:02 cw_volcano 阅读(162) 评论(0) 编辑收藏举报