create database school on primary ( name = data1,filename = 'D:\Sqldata\datagroup\data1.mdf',sizecreate database schoolon primary(name = data1,filename = 'D:\Sqldata\datagroup\data1.mdf',size= 10,maxsize=100,filegrowth = 5),(name=data2,filename='D:\S

来源:学生作业帮助网 编辑:作业帮 时间:2024/10/06 23:33:45
create database school on primary ( name = data1,filename = 'D:\Sqldata\datagroup\data1.mdf',sizecreate database schoolon primary(name = data1,filename = 'D:\Sqldata\datagroup\data1.mdf',size= 10,maxsize=100,filegrowth = 5),(name=data2,filename='D:\S
xTNP0i $UٹRnTmҗc1Bemta|7+ Ըr3Ν9ܙifrƒ Y)/e yPM! `fUnB#S ͜eLegC\NY.r>Fe.D|CxB'2V 1&|w u)Uyk]1^&Wxcm &-5BVBw@I  j̱8֖j-%*D06ܺMw+۴TG#ݦǹcn^2k5 \1!pmС;Tm:qc)1$iqTJj'"f2S?WE╋qqTcZ{W)-kZ?Ƕ{Ni}8ə Y]&

create database school on primary ( name = data1,filename = 'D:\Sqldata\datagroup\data1.mdf',sizecreate database schoolon primary(name = data1,filename = 'D:\Sqldata\datagroup\data1.mdf',size= 10,maxsize=100,filegrowth = 5),(name=data2,filename='D:\S
create database school on primary ( name = data1,filename = 'D:\Sqldata\datagroup\data1.mdf',size
create database school
on
primary
(
name = data1,
filename = 'D:\Sqldata\datagroup\data1.mdf',
size= 10,
maxsize=100,
filegrowth = 5),
(
name=data2,
filename='D:\Sqldata\datagroup\data2.ndf',
size=10,
maxsize=100,
filegrowth=5),
filegroup datagroup
(name=data11,
filename='D:\Sqldata\datagroup\data11.ndf',
size=10,
maxsize=100,
filegroup=5),
(name=data21,
filename='D:\Sqldata\datagroup\data21.ndf',
size=10,
maxsize=100,
filegroup=5),
log on
(
name = schoollog,
filename ='D:\Sqldata\datagroup\schoollog.ldf',
size=10mb,
maxsize =unlimited,
filegrowth =10%
)
加上单位后 服务器:消息 155,级别 15,状态 1,行 21
'filegroup' 不是可以识别的 CREATE/ALTER DATABASE 选项.

create database school on primary ( name = data1,filename = 'D:\Sqldata\datagroup\data1.mdf',sizecreate database schoolon primary(name = data1,filename = 'D:\Sqldata\datagroup\data1.mdf',size= 10,maxsize=100,filegrowth = 5),(name=data2,filename='D:\S
size= 10,
maxsize=100,
filegrowth = 5),
等没有单位,应该会影响执行的.
D:\Sqldata\datagroup
目录是否存在也会影响执行的.