关于一个脚本，急救！！！！！

[ck85]

use master
go
create database linedate
on
primary (name=linedata1
filename="D:\Microsoft SQL Server\MSSQL\Data\linedata1.mdf",
size=5MB,
maxsize=500MB,
filegrowth=5MB),
(name=linedata2
filename="D:\Microsoft SQL Server\MSSQL\Data\linedata2.ndf",
size=5MB,
maxsize=500MB,
filegrowth=5MB),
(name=linedata3
filename="D:\Microsoft SQL Server\MSSQL\Data\linedata3.ndf",
size=5MB,
maxsize=500MB,
filegrowth=5MB)
log on
(name=linedatalog1
filename="D:\Microsoft SQL Server\MSSQL\Data\linedatalog1.ldf",
size=2MB,
maxsize=50MB,
filegrowth=3MB),
(name=linedatalog2
filename="D:\Microsoft SQL Server\MSSQL\Data\linedatalog2.ldf",
size=2MB,
maxsize=50MB,
filegrowth=3MB)
go

对于这个脚本，给出如下提示：
服务器: 消息 153，级别 15，状态 1，行 4
在 CREATE/ALTER DATABASE 语句中有 filename 选项的无效使用。



这是为什么啊？谢谢大虾了！

[txlicenhe]

将双引号换成单引号。

[pengdali]

use master
go
create database linedate
on
primary (name=linedata1,
filename='D:\Microsoft SQL Server\MSSQL\Data\linedata1.mdf',
size=5MB,
maxsize=500MB,
filegrowth=5MB),
(name=linedata2,
filename='D:\Microsoft SQL Server\MSSQL\Data\linedata2.ndf',
size=5MB,
maxsize=500MB,
filegrowth=5MB),
(name=linedata3,
filename='D:\Microsoft SQL Server\MSSQL\Data\linedata3.ndf',
size=5MB,
maxsize=500MB,
filegrowth=5MB)
log on
(name=linedatalog1,
filename='D:\Microsoft SQL Server\MSSQL\Data\linedatalog1.ldf',
size=2MB,
maxsize=50MB,
filegrowth=3MB),
(name=linedatalog2,
filename='D:\Microsoft SQL Server\MSSQL\Data\linedatalog2.ldf',
size=2MB,
maxsize=50MB,
filegrowth=3MB)
go

[zjcxc]

use master
go
create database linedate
on
primary (name=linedata1, --少了逗号
FILENAME='D:\Microsoft SQL Server\MSSQL\Data\linedata1.mdf', --应该用单引号
size=5MB,
maxsize=500MB,
filegrowth=5MB),
(name=linedata2,
filename='D:\Microsoft SQL Server\MSSQL\Data\linedata2.ndf',
size=5MB,
maxsize=500MB,
filegrowth=5MB),
(name=linedata3,
filename='D:\Microsoft SQL Server\MSSQL\Data\linedata3.ndf',
size=5MB,
maxsize=500MB,
filegrowth=5MB)
log on
(name=linedatalog1,
filename='D:\Microsoft SQL Server\MSSQL\Data\linedatalog1.ldf',
size=2MB,
maxsize=50MB,
filegrowth=3MB),
(name=linedatalog2,
filename='D:\Microsoft SQL Server\MSSQL\Data\linedatalog2.ldf',
size=2MB,
maxsize=50MB,
filegrowth=3MB)
go