Solved

T-SQL Error - NON_TRANSACTED_ACCESS

Posted on 2014-02-07
3
1,917 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:
Deepak Chauhan 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

Back Up Your Microsoft Windows Server®

Back up all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
T-SQL 10 32
MS SQL Update query with connected table data 3 30
SQL DATEADD 10 70
SQL Backup Question 2 29
Everyone has problem when going to load data into Data warehouse (EDW). They all need to confirm that data quality is good but they don't no how to proceed. Microsoft has provided new task within SSIS 2008 called "Data Profiler Task". It solve th…
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

790 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