SQL2008生成的数据库脚本在SQL2000上执行时需修改的地方
SQL2008生成的数据库脚本在SQL2000上执行时需注意的地方
1. @level0type=N'SCHEMA' 替换为@level0type=N'USER'
2 .WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] 全部删除(生成创建表语句时的代码)
3. sys.sp_addextendedproperty替换为dbo.sp_addextendedproperty
1. @level0type=N'SCHEMA' 替换为@level0type=N'USER'
2 .WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] 全部删除(生成创建表语句时的代码)
3. sys.sp_addextendedproperty替换为dbo.sp_addextendedproperty
posted on 2009-04-27 12:41 ξσ Dicky σξ 阅读(891) 评论(0) 编辑 收藏 举报
