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