← Tutti gli articoli

SQL Server 2008 - The FILESTREAM attribute.

04 luglio 2012  · Troubleshooting · Article  ·  517 visite

Function PathName is only valid on columns with the FILESTREAM attribute.

When you create the field of your table remember the FILESTREAM attribute:
  1. CREATE   TABLE  [dbo].[Files](  
  2.     [FileId] [int] NOT NULL,  
  3.     [ImportId] [int] NOT NULL,  
  4.     [Filename] [nvarchar](255) NOT NULL,  
  5.     [FileGuid] [uniqueidentifier] ROWGUIDCOL  NOT NULL,  
  6.     [FileContent] [varbinary](max) FILESTREAM NOT NULL    
  7. )