I have created a filetable with full access and created a trigger on Filetable to insert the filename and streamid to another normal table.Everything was working as expect but when i moved the same setup from one server to another the file insertion to folder failed with below errors.
--when tried using TQL
Msg 33409, Level 16, State 1, Line 11
The operation caused a FileTable check constraint error. A file entry cannot have a NULL value for the data stream associated with the row. Insert file data or use 0x to insert a zero length file.
--when copied the file to location
The system cannot find message text for message number 0xfilename.sql in the message file for (null).
if i remove the trigger the copying works fine.
The difference between two servers are one is using disks and the other one is having mount points.