消息156 级别15 急!!!

来源:百度知道 编辑:UC知道 时间:2024/06/01 14:41:04
ALTER DATABASE studentDZ07314
ADD FILE
(NAME= studentdata3,
FILENAME='C:\Program Files\Microsoft SQL Server\MSSQL\Data\tdat3.ndf',
SIZE=5MB,
MAXSIZE=50MB,
FILEGROWTH=5),
(NAME=studentdat4,
FILENAME='C:\Program Files\Microsoft SQL Server\MSSQL\Data\tdat4.ndf',
SIZE=5MB,
MAXSIZE=50MB,
FILEGROWTH=5)
TO FILEGROUP studentFG1
ADD LOG FILE
(NAME=studentlog2,
FILENAME='D:\studentlog2\studentlog.ldf',
SIZE=5,MAXSIZE=100,FILEGROWTH=5)
在关键字 'ADD' 附近有语法错误。
h还是不对啊

ALTER DATABASE studentDZ07314
ADD FILE
(NAME= studentdata3,
FILENAME='C:\Program Files\Microsoft SQL Server\MSSQL\Data\tdat3.ndf',
SIZE=5MB,
MAXSIZE=50MB,
FILEGROWTH=5),
(NAME=studentdat4,
FILENAME='C:\Program Files\Microsoft SQL Server\MSSQL\Data\tdat4.ndf',
SIZE=5MB,
MAXSIZE=50MB,
FILEGROWTH=5)
TO FILEGROUP studentFG1
ADD LOG FILE
(NAME=studentlog2,
FILENAME='D:\studentlog2\studentlog.ldf',
SIZE=5,MAXSIZE=100,FILEGROWTH=5)
在关键字 'ADD' 附近有语法错误。