September 18, 2008 at 4:19 am
hi,
Is it possible to add a FileStream for a column in a table which has a int data type with primary Key constraints as another column.
September 18, 2008 at 4:40 am
Filestream requires that there's a column in the table or type ROWGUIDCOL. The rest of the table (as far as I know) doesn't matter.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 18, 2008 at 5:30 am
I've only started testing filestream but, other than what Gail has already outlined, there are no other restrictions on columns in the table. That's a big part of the idea behind it. You treat the column that is using the file system through the filestream just like any other column. The rest of the table largely doesn't matter (so far).
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply