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

FileStream whitepaper needed

There are still a bunch of questions and recommendations needed about the new Filestream datatype. I guess it is transactionnally consistent (not like Oracle's BFile), but what are the impacts on the transactional log? What are the recommended ways to use it? etc.

If we envision db with a few terabytes (and more), are we out of our minds or is it really in reach? (without NASA technology and Military budget).

thanks.

PS: this is still not beyond relational. Only marketing people can label it as such. There is nothing in relational therory againsts Filestreams or XML. On the contrary, (MS)SQL is becoming more relational with these technologies. Applauds!!

Hi Lakusha,

Documentation for Filestream will be available in Books Online in the CTP release in which this feature is included.

Regards,

Gail

|||

What's the expected timeframe for the next CTP release (SQL Server 2008 and Books Online)?

|||

Hi Anders,

A release date for the next CTP has not been set yet.

FileStream whitepaper needed

There are still a bunch of questions and recommendations needed about the new Filestream datatype. I guess it is transactionnally consistent (not like Oracle's BFile), but what are the impacts on the transactional log? What are the recommended ways to use it? etc.

If we envision db with a few terabytes (and more), are we out of our minds or is it really in reach? (without NASA technology and Military budget).

thanks.

PS: this is still not beyond relational. Only marketing people can label it as such. There is nothing in relational therory againsts Filestreams or XML. On the contrary, (MS)SQL is becoming more relational with these technologies. Applauds!!

Hi Lakusha,

Documentation for Filestream will be available in Books Online in the CTP release in which this feature is included.

Regards,

Gail

|||

What's the expected timeframe for the next CTP release (SQL Server 2008 and Books Online)?

|||

Hi Anders,

A release date for the next CTP has not been set yet.

FileStream whitepaper needed

There are still a bunch of questions and recommendations needed about the new Filestream datatype. I guess it is transactionnally consistent (not like Oracle's BFile), but what are the impacts on the transactional log? What are the recommended ways to use it? etc.

If we envision db with a few terabytes (and more), are we out of our minds or is it really in reach? (without NASA technology and Military budget).

thanks.

PS: this is still not beyond relational. Only marketing people can label it as such. There is nothing in relational therory againsts Filestreams or XML. On the contrary, (MS)SQL is becoming more relational with these technologies. Applauds!!

Hi Lakusha,

Documentation for Filestream will be available in Books Online in the CTP release in which this feature is included.

Regards,

Gail

|||

What's the expected timeframe for the next CTP release (SQL Server 2008 and Books Online)?

|||

Hi Anders,

A release date for the next CTP has not been set yet.

sql