Answer the question
In order to leave comments, you need to log in
Syntax error (example position: "ON"). Mistake?
CREATE DATABASE MyDB
ON
(NAME = MyDBroot,
FILENAME = "C:\mssql2k\MSSQL\data\mydbroot.mdf",
SIZE = 8MB,
MAXSIZE = 9MB,
FILEGROWTH = 100KB),
(NAME = MyDBdata1,
FILENAME = "C:\mssql2k\MSSQL\data\mydbdata1.ndf",
SIZE = 1000MB,
MAXSIZE = 1500MB,
FILEGROWTH = 100MB)
LOG ON
(NAME = Logdata1,
FILENAME = "D:\log_files\logdata1.ldf",
SIZE = 1000MB,
MAXSIZE = 1500MB,
FILEGROWTH = 100MB)
Answer the question
In order to leave comments, you need to log in
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question