Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2155
  • Last Modified:

T-SQL Error - NON_TRANSACTED_ACCESS

I am getting error "Msg 102, Level 15, State 25, Line 14 Incorrect syntax near 'FILESTREAM'." and I cannot figure it out.  Something to do with the NON_TRANSACTED_ACCESS.


CREATE DATABASE MyFileTableTest  
ON  PRIMARY  
(  
NAME = N'MyFileTableTest',  
FILENAME = N'C:\FileTable\MyFileTableTest.mdf'  
),  
FILEGROUP FilestreamFG CONTAINS FILESTREAM      
(  NAME = MyFileStreamData,  
FILENAME= 'C:\FileTable\Data'  
)  
LOG ON  
(  
NAME = N'MyFileTableTest_Log',  
FILENAME = N'C:\FileTable\MyFileTableTest_log.ldf'  
)  
WITH FILESTREAM  
(  NON_TRANSACTED_ACCESS = FULL,  
DIRECTORY_NAME = N'FileTable'  
)
0
hojohappy
Asked:
hojohappy
1 Solution
 
Deepak ChauhanSQL Server DBACommented:
I think you are executing above statement in SQL Server 2008. If yes, then please remove the lines "WITH FILESTREAM  
(  NON_TRANSACTED_ACCESS = FULL,  
DIRECTORY_NAME = N'FileTable'  
)".
0
 
hojohappyAuthor Commented:
No.  I am running this in on SQL Server 2012 Express
0
 
Anthony PerkinsCommented:
I am running this in on SQL Server 2012 Express
That may be true, but what is the Compatibility level of the database?
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now