I have a table that uses the FILESTREAM attribute for SQL Server 2008. If I edit it in the 2008 SSMS table designer, the FILESTREAM attribute is lost. Most folks say to use ALTER to put it back. Problem is that every example I see shows creating a brand new table or brand new column. I can drop and re-add the column but then I lose my data. What happens if I have a table in production with existing filestream data and need to put the FILESTREAM attribute back on the column without losing the data in the column?
I tried and get this:
Cannot alter column 'Data' in table 'accnt_attachment' to add or remove the FILESTREAM column attribute.
Obviously I do not have the correct syntax. An example would be greatly appreciated.
View Complete Post