读书人

有了SQL脚本怎样执行它在SQL2008里建

发布时间: 2012-02-22 19:36:55 作者: rapoo

有了SQL脚本,怎样执行它在SQL2008里建立数据库
rt,怎么在SSMS里执行啊?
我点New Query和Database Engine Query执行那个*.sql脚本老报错...脚本是人家写好的
错误提示如下:
1. The CREATE DATABASE statement failed. The primary file must be at least 3 MB to accommodate a copy of the model database.
2. Database '***Database' does not exist. Make sure that the name is entered correctly.
3. User does not have permission to alter database '***Database', the database does not exist, or the database is not in a state that allows access checks.

[解决办法]


检查一下你的这个文件中的 create database 语句。 你设置的主文件过小了。或者没有指定。
[解决办法]
1. The CREATE DATABASE statement failed. The primary file must be at least 3 MB to accommodate a copy of the model database.
2. Database '***Database' does not exist. Make sure that the name is entered correctly.
3. User does not have permission to alter database '***Database', the database does not exist, or the database is not in a state that allows access checks.

检查一下MASTER、MODEL数据库,是否设置过小
[解决办法]


WWWWA检查一下MASTER、MODEL数据库,是否设置过小

[解决办法]
呵呵,自己解决更好,扩大数据库的体积吗?

读书人网 >数据库开发

热点推荐