I'm doing a VERY simple CREATE DATABASE, but for some reason it's failing.
I go int SSMS and try to create a database called 'TEST'. No frills, nothing fancy. I accept all the defaults. I click okay, but then within a couple of seconds, an error is thrown. Here's the T-SQL:
CREATE DATABASE [test123] ON PRIMARY
( NAME = N'test', FILENAME = N'H:\SQLData\test.mdf' , SIZE = 3072KB , FILEGROWTH = 1024KB )
( NAME = N'test_log', FILENAME = N'G:\SQLLog\test_log.ldf' , SIZE = 44032KB , FILEGROWTH = 10%)
The error is stating "incorrect syntax near hte keyword 'on' "?!?!? Huh?!?!?
When I run the exact same command on a different server, it works fine.
What is going on?
A. M. Robinson
View Complete Post