Tuesday, April 12, 2011 8:06 PM
I have read about Filetable feature of SQL Server 2011 and have try this feature by myself. I installed SQL Server Denali CTP1 and try the exemple from BOL.
CREATE TABLE DocumentStore AS FileTable WITH FileTable_Directory Document
But it has raised errors
Msg 156, Level 15, State 1, Line 22
Incorrect syntax near the keyword 'AS'.
Msg 319, Level 15, State 1, Line 22
Incorrect syntax near the keyword 'with'. If this statement is a common table expression, an xmlnamespaces clause or a change tracking context clause, the previous statement must be terminated with a semicolon.
As I can see, the CTP1 does not support the Filetable. Is it true or I did something wrong?
Wednesday, April 13, 2011 12:22 AM
Wednesday, April 13, 2011 7:10 AMThanks.
Friday, July 15, 2011 1:41 PM
It is now included in CTP3
Share the SQL Server Experience
Friday, July 15, 2011 5:02 PM
The Books Online documentation for FileTable is here: http://msdn.microsoft.com/en-us/library/ff929144(SQL.110).aspx
Gail Erickson [MSFT] This posting is provided "AS IS" with no warranties, and confers no rights