Im am trying to do this SQL code;
CREATE DATABASE AdventureWorks2012 ON (FILENAME = '{drive}:\
{file path}\AdventureWorks2012_Data.mdf')
I am getting the following error when i run it:
Msg 1036, Level 16, State 2, Line 1
File option NAME is required in this CREATE/ALTER DATABASE statement.
My file location is: '{c}:/AAPOLLIS-M/Users/aapollis/Downloads/AdventureWorks2012_Data.mdf')
What am i doing wrong? Running on SQL Server 2014(free or trial version).