当前位置: 代码迷 >> 数据仓库 >> 有了SQL脚本,怎样执行它在SQL2008里建立数据库解决方案
  详细解决方案

有了SQL脚本,怎样执行它在SQL2008里建立数据库解决方案

热度:109   发布时间:2016-05-05 16:12:03.0
有了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数据库,是否设置过小

------解决方案--------------------
呵呵,自己解决更好,扩大数据库的体积吗?
  相关解决方案