SQL2008生成的数据库脚本在SQL2000上执行时需注意的地方1. @level0type=N'SCHEMA' 替换为@level0type=N'USER'2 .WITH (PAD_INDEX= OFF, STATISTICS_NORECOMPUTE=......
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
|
