Avatar of Abdu_Allah
Abdu_Allah
 asked on

Does SQL Server 2008 Express supports FileStream?

Hi, I need a certain answer please.
Microsoft SQL Server 2008

Avatar of undefined
Last Comment
Guy Hengel [angelIII / a3]

8/22/2022 - Mon
RiteshShah

yes, it supports
ASKER CERTIFIED SOLUTION
RiteshShah

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
Abdu_Allah

ASKER
So why I'm getting error: Incorrect syntax near 'FILESTREAM'.
RiteshShah

you might be doing something wrong in syntax I guess.
Experts Exchange is like having an extremely knowledgeable team sitting and waiting for your call. Couldn't do my job half as well as I do without it!
James Murphy
Abdu_Allah

ASKER
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;
 
Abdu_Allah

ASKER
Did you guys work on FILESTREAM on Express 2008 yourselves?
RiteshShah

>>Did you guys work on FILESTREAM on Express 2008 yourselves?<<

not on express but used it in enterprise
⚡ FREE TRIAL OFFER
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.
SOLUTION
RiteshShah

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
⚡ FREE TRIAL OFFER
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.
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?
Abdu_Allah

ASKER
here is the screenshot:

Untitled.png
Guy Hengel [angelIII / a3]

you installed 32-bit sql server?!
Your help has saved me hundreds of hours of internet surfing.
fblack61
Abdu_Allah

ASKER
Yub
SOLUTION
Guy Hengel [angelIII / a3]

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
⚡ FREE TRIAL OFFER
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.
Abdu_Allah

ASKER
Really? So FILESTREAM feature works only on 64-bit of 2008-Express? Any documentation on that please?
Guy Hengel [angelIII / a3]

⚡ FREE TRIAL OFFER
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.
Abdu_Allah

ASKER
Thank you I read that thread but cannot find they mentioned that, can you please point me to where they mention that?
Guy Hengel [angelIII / a3]

I fear that you have to contact MS directly to get that file ...