SQLTeam.com | Weblogs | Forums

Filestream file


#1

i have a table
[ImageId] [int] IDENTITY(1,1) NOT NULL,
[ImageType] varchar NULL,
[Description] varchar NULL,
[MIMEType] varchar NULL,
[FileSize] [bigint] NULL,
[CreatedBy] varchar NOT NULL,
[CreatedOn] [datetime] NOT NULL,
[ModifiedBy] varchar NOT NULL,
[ModifiedOn] [datetime] NOT NULL,
[fsguid] [uniqueidentifier] ROWGUIDCOL NOT NULL,
[ImageBinary] varbinary FILESTREAM NULL,

one of the file is missing. i know the fsguid and this table has a record. i found the windows share path for filestream but can't access it. i am trying to find the file name (one i can see in the filestream folder).
how to find it? please advise.

if i can get the file name than i will put a dummy file there with that name