Is it possible to have two FILESTREAM columns in one table?

Question

From what I've read nothing explicitly says you cannot have two FILESTREAM columns in one table, but given that you need a ROWGUIDCOL identifier for the FILESTREAM to work, and you cannot have two of those, is it possible?

Can I use the same ROWGUIDCOL but with two different FILESTREAM groups?

Answer 1

There are several Windows and SQL Server requirements that must be met before you can use the FILESTREAM data type. You should review the white paper located here "http://msdn.microsoft.com/en-us/library/cc949109.aspx" and titled "FILESTREAM Storage in SQL Server 2008".

I quote the section of the document that answers your specific question: "A table can have multiple FILESTREAM columns, but the data from all FILESTREAM columns in a table must be stored in the same FILESTREAM filegroup. If the FILESTREAM_ON clause is not specified, whichever FILESTREAM filegroup is set to be the default will be used. This may not be the desired configuration and could lead to performance problems."