I am trying to create directories in a SQL Server FileTable via a stored procedure where I call the following code:
INSERT INTO tblMyFiles (name, is_directory, is_archive)
VALUES ('foldername', 1, 0);
After calling this code I can see the row sitting in the File Table if I select the rows in SQL Server Management Studio but if I explore to the File Table directory via Windows Explorer I can not see the newly created directory. If I refresh Windows Explorer then the directory still does not show up. If I create a file in the File Table directory in Explorer then it seems to wake Explorer up and then all my directories that were created via the stored procedure appear.
I do not run into this problem when running this on the same SQL box and for a different database and I have compared all the properties and they appear identical but I must be missing something and don't know what? Any help would be much appreciated. Thanks in advance