首页 诗词 字典 板报 句子 名言 友答 励志 学校 网站地图
当前位置: 首页 > 教程频道 > 数据库 > 数据库开发 >

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

2012-02-22 
有了SQL脚本,怎样执行它在SQL2008里建立数据库rt,怎么在SSMS里执行啊?我点New Query和Database Engine Que

有了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数据库,是否设置过小

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

热点排行