Link to home
Start Free TrialLog in
Avatar of Abdu_Allah
Abdu_Allah

asked on

Does SQL Server 2008 Express supports FileStream?

Hi, I need a certain answer please.
Avatar of RiteshShah
RiteshShah
Flag of India image

yes, it supports
ASKER CERTIFIED SOLUTION
Avatar of RiteshShah
RiteshShah
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Abdu_Allah
Abdu_Allah

ASKER

So why I'm getting error: Incorrect syntax near 'FILESTREAM'.
you might be doing something wrong in syntax I guess.
No, here is what I'm doing:
GO
CREATE TABLE DocumentStore (
       DocumentID INT IDENTITY PRIMARY KEY,
       Document VARBINARY (MAX) FILESTREAM NULL,
       DocGUID UNIQUEIDENTIFIER NOT NULL ROWGUIDCOL
              UNIQUE DEFAULT NEWID ())
FILESTREAM_ON FileStreamGroup1;
 
Did you guys work on FILESTREAM on Express 2008 yourselves?
>>Did you guys work on FILESTREAM on Express 2008 yourselves?<<

not on express but used it in enterprise
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Guy Hengel [angelIII / a3]
q: is the FILESTREAM enabled?
http://msdn.microsoft.com/en-us/library/cc645923.aspx

q: did you create the proper filegroup?
http://msdn.microsoft.com/en-us/library/cc645585.aspx

q: what is the database compatibility mode?
here is the screenshot:

Untitled.png
you installed 32-bit sql server?!
Yub
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Really? So FILESTREAM feature works only on 64-bit of 2008-Express? Any documentation on that please?
Thank you I read that thread but cannot find they mentioned that, can you please point me to where they mention that?
I fear that you have to contact MS directly to get that file ...