FILESTREAM: in or not there yet?

I guess the Subject says it all: Is FILESTREAM in the latest CTP or not? The reason I'm asking is that when searching the latest BOL, there are pointers to FILESTREAM, but when trying to use it in code I'm getting an incorrect syntax error.

Thanks!

Niels

No Niels, did not heard or saw something in it. Same was for the Merge statement in the last CTP, it was in the BOL, the Studio colored it, but it was not recognized by the parser.

Jens K. Suessmeyer

http://www.sqlserver2005.de

|||Thanks Jens, let's assume it's not there yet then :-)

Niels
|||Filestream is not in the current CTP yet. It should be in the next one.

Thanks,|||Thanks Marcel!

Niels

files, filegroups

Can someone tell me if we can move files to different filegroups in SQL2K5? If we can, how do you do it?

Here is an excerpt from BOL.

REMOVE FILEGROUP filegroup_name
Removes a filegroup from the database. The filegroup cannot be removed unless it is empty. Remove all files from the filegroup first by either ***moving the files to another filegroup*** or, if the files are empty, by removing the files.

Is that a typo or what?

Thanks.I am hoping Microsoft folks will reply to this. Please let me know if the BOL has an error or you can actually move files among filegroups.
|||

This is a doc error. We can not move files between filegroups.

I've reported the problem to our doc team.

Thanks for reporting it here.

sql