有了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数据库,是否设置过小
[解决办法]