Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
mteriyaki
Starting Member
3 Posts |
 Posted - 2010-04-04 : 20:06:51
|
| Sorry I know this is probably simple, but I can't seem to figure out what is wrong with this (I took it almost straight out of the book...)CREATE DATABASE FinalProject ON Primary (NAME= N'FinalData', FILENAME=N'C:\FinalProj\final.mdf', SIZE=8MB, MAXSIZE=UNLIMITED, FILEGROWTH=16MB),FILEGROUP FG1 (NAME=N'FinalData2', FILENAME=N'C:\FinalProj\final.ndf', SIZE=8MB, MAXSIZE=UNLIMITED, FILEGROWTH=16MB), LOG ON(NAME=N'FinalProj_Log', FILENAME=N'C:\FinalProj\final.ldf', SIZE=8MB, MAXSIZE=UNLIMITED, FILEGROWTH=16MB)It gives me an error around the LOG word.Thanks for any help... |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2010-04-04 : 20:20:47
|
remove the comma before the LOG ON
KH[spoiler]Time is always against us[/spoiler] |
 |
|
|
mteriyaki
Starting Member
3 Posts |
Posted - 2010-04-04 : 20:25:04
|
| yay!! thank you so much! |
|
|
|
|
|
|
|
|
Basic stuff... CREATE statement trouble