What is wrong with this query? It does not make any difference what I change the name to, I get the same error message with the new name!!
CREATE DATABASE MyFileTable
ON PRIMARY
(
Name = MyFileTable_data,
FILENAME = 'I:\Developement\FileTable\MyFileTable.mdf'
),
FILEGROUP FileStreamFG Contains Filestream
(
NAME = MyFileTable,
FileName = 'I:\Developement\FileTable\MyFileTable_Container'
)
LOG ON
(
NAME = MyFileTable,
FileName = 'I:\Developement\FileTable\MyFileTable_Log.ldf'
)
WITH FILESTREAM
(
NON_TRANSACTED_ACCESS = FULL,
DIRECTORY_NAME = N 'FileTableContainer'
)
Go
Error:
Msg 1828, Level 16, State 5, Line 1
The logical file name "whatever the file name is" is already in use. Choose a different name.
Completion time: 2021-05-22T13:48:00.5850750-04:00
