I've got a table that uses the SQL 2008 FILESTREAM feature for storing binary data within a filegroup.
This feature is not supported by Management Studio so any designer modification will remove the feature from the column.
My question is, how would one recover from this? Reattaching the attribute and the binary data link to the filegroup? It doesn’t seem possible?
With thousands of records this could mean massive data issues should someone modify the table with the GUI.
View Complete Post