Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Administration
 How to create a FILESTREAM col in GUI

Author  Topic 

ozSQLServer
Starting Member

32 Posts

Posted - 2011-09-07 : 23:45:51
Hi,

I've successfully created a column of type VARBINARY(MAX) with FILESTREAM property using ALTER TABLE .. ADD command.

My question is: how can I make it using the GUI SQL Server Management Studio?

When I right clicked on a table and selected "Design", I couldn't find a way to set the FILESTREAM property for a column.

Cheers,
ozSQL

Lumbago
Norsk Yak Master

3271 Posts

Posted - 2011-09-08 : 08:38:47
I just tried and it seems it can't be done. T-SQL is the only way...

- Lumbago
My blog-> http://thefirstsql.com/2011/07/08/how-to-find-gaps-in-identity-columns-at-the-speed-of-light/
Go to Top of Page

steve_r18
Yak Posting Veteran

59 Posts

Posted - 2011-09-08 : 11:50:54
http://msdn.microsoft.com/en-us/library/cc645923.aspx

He's right. MS acknowledges T-SQL is the only way to go. Initial enabling can be done through the configuration manager but that's it.


Steve
Go to Top of Page

alexylee
Starting Member

14 Posts

Posted - 2011-09-08 : 14:34:13
If someone wants to see how to enable/use FileStream:
http://sqlbeyond.blogspot.com/2011/08/how-to-use-filestream.html
Go to Top of Page

ozSQLServer
Starting Member

32 Posts

Posted - 2011-09-08 : 18:58:48
Thanks folks!

Cheers,
ozSQL
Go to Top of Page
   

- Advertisement -