Does SQL Server Denali CTP1 support Filetable feature?

Question

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
    FILESTREAM_ON FILESTREAMGroup1;

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?

Answer 1

No, this feature isn’t in CTP1. See: http://www.sqlskills.com/BLOGS/BOBB/post/Whats-new-in-Denali-CTP1-And-what-isnt-in-CTP1.aspx

 

Cheers, Bob

 

 

"Bezzz" wrote in message news:bb815347-763e-4897-a25c-179b9b232637...

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
    FILESTREAM_ON FILESTREAMGroup1;

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?

Answer 2

Thanks.

Answer 3

It is now included in CTP3

---

Share the SQL Server Experience

 

Answer 4

The Books Online documentation for FileTable is here:  http://msdn.microsoft.com/en-us/library/ff929144(SQL.110).aspx

Gail

---

Gail Erickson [MSFT] This posting is provided "AS IS" with no warranties, and confers no rights