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.
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...- LumbagoMy blog-> http://thefirstsql.com/2011/07/08/how-to-find-gaps-in-identity-columns-at-the-speed-of-light/ |
|
|
steve_r18
Yak Posting Veteran
59 Posts |
Posted - 2011-09-08 : 11:50:54
|
http://msdn.microsoft.com/en-us/library/cc645923.aspxHe'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 |
|
|
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 |
|
|
ozSQLServer
Starting Member
32 Posts |
Posted - 2011-09-08 : 18:58:48
|
Thanks folks!Cheers,ozSQL |
|
|
|
|
|