Altering database to include FileTable gives me syntax error
I have an existing database and I'd like to take advantage of the
FileTable feature in SQL Server 2012. Looking online, this is how I update
the database:
ALTER DATABASE MyDB
ADD FILEGROUP MyDBFiles CONTAINS FILESTREAM
(
NAME = SomeCoolName,
FILENAME= 'C:\FileTable\Data'
)
GO
However, I get Incorrect syntax near 'NAME' error.
What am I doing wrong?
No comments:
Post a Comment