Solved

T-SQL Error - NON_TRANSACTED_ACCESS

Posted on 2014-02-07
3
1,866 Views
Last Modified: 2014-02-22
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
Comment
Question by:hojohappy
3 Comments
 
LVL 15

Accepted Solution

by:
deepakChauhan earned 500 total points
ID: 39843844
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
 

Author Comment

by:hojohappy
ID: 39844106
No.  I am running this in on SQL Server 2012 Express
0
 
LVL 75

Expert Comment

by:Anthony Perkins
ID: 39844617
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

Zoho SalesIQ

Hassle-free live chat software re-imagined for business growth. 2 users, always free.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I wrote this interesting script that really help me find jobs or procedures when working in a huge environment. I could I have written it as a Procedure but then I would have to have it on each machine or have a link to a server-related search that …
Having an SQL database can be a big investment for a small company. Hardware, setup and of course, the price of software all add up to a big bill that some companies may not be able to absorb.  Luckily, there is a free version SQL Express, but does …
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.

863 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now