Does the standard version supports the filestream?

Question

Does the standard version supports the filestream?

eko indriyawan

Hall of Fame

Points: 3316
More actions
October 20, 2009 at 10:35 am

#215772

Does the standard version supports the filestream?
for the express version, I've checked do not support
Best Regards
Eko Indriyawan

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Lowell SSC Guru Points: 323504 More actions · Answer 1

not true; SQL 2008 Express supports filestream:

Microsoft (10/20/2009)
http://msdn.microsoft.com/en-us/library/cc949109.aspx
SQL Server Express
SQL Server Express supports FILESTREAM. The 4-GB database size limit does not include the FILESTREAM data container.
However, if FILESTREAM data is being sent to or from the SQL Server Express instance using Service Broker, then care must be taken, because Service Broker does not support storing data as FILESTREAM in the transmission or target queues. This means that if either queue builds up, the 4-GB database size limit may be reached.

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

eko indriyawan Hall of Fame Points: 3316 More actions · Answer 2

I apologize if that's not true, but when I execute this query always raises an error message

USE MASTER

GO

EXEC sp_FILESTREAM_configure @enable_level = 2

GO

error message:

Msg 2812, Level 16, State 62, Line 1

Could not find stored procedure 'sp_FILESTREAM_configure'.

please advise

Lowell SSC Guru Points: 323504 More actions · Answer 3

the command you pasted is just one piece (actually the last step) of enabling FILESTREAM on 2008:

it's got a syntax error as well; it should be thisL

EXEC sp_configure filestream_access_level, 2

RECONFIGURE

http://msdn.microsoft.com/en-us/library/cc645923.aspx

Before you can start to use FILESTREAM, you must enable FILESTREAM on the instance of the SQL Server Database Engine. This topic describes how to enable FILESTREAM by using SQL Server Configuration Manager.
On the Start menu, point to All Programs, point to Microsoft SQL Server 2008, point to Configuration Tools, and then click SQL Server Configuration Manager.
In the list of services, right-click SQL Server Services, and then click Open.
In the SQL Server Configuration Manager snap-in, locate the instance of SQL Server on which you want to enable FILESTREAM.
Right-click the instance, and then click Properties.
In the SQL Server Properties dialog box, click the FILESTREAM tab.
Select the Enable FILESTREAM for Transact-SQL access check box.
If you want to read and write FILESTREAM data from Windows, click Enable FILESTREAM for file I/O streaming access. Enter the name of the Windows share in the Windows Share Name box.
If remote clients must access the FILESTREAM data that is stored on this share, select Allow remote clients to have streaming access to FILESTREAM data.
Click Apply.
In SQL Server Management Studio, click New Query to display the Query Editor.
In Query Editor, enter the following Transact-SQL code:
Copy Code
EXEC sp_configure filestream_access_level, 2
RECONFIGURE
Click Execute.

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

eko indriyawan Hall of Fame Points: 3316 More actions · Answer 4

eko indriyawan

Hall of Fame

Points: 3316

October 20, 2009 at 11:33 am

#1068376

Thank you very much.

King Regards,

Eko Indriyawan